SQLTeam.com | Weblogs | Forums

SQL Server 2008 Merge Replication

sql2008r2
sql2008

#1

Hello Everybody.

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.

Please help.

Thanks in advance

Abhishek Jadhav


#2

Make sure your db has the required ANSI settings, then try again:

ALTER DATABASE [your_db_name] SET ANSI_NULLS ON;
ALTER DATABASE [your_db_name] SET ANSI_PADDING ON;
ALTER DATABASE [your_db_name] SET CONCAT_NULL_YIELDS_NULL ON;