I am trying to use Merge Replication. When I try to enable the database for Merge Publication from - Replication > Publisher properties > Publication Database., system is giving an error message which is as below.
select failed because the following set options have incorrect settings: "ANSI_PADDING". Verify that SET options are correct for used with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or special index operations.
Thanks in advance