SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 Merge replication ANSI_NULLS settings
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

aboe
Starting Member

4 Posts

Posted - 05/14/2013 :  02:55:22  Show Profile  Reply with Quote
Hi,

We have a database with ANSI_NULLS OFF.
When adding a Merge replication, publication triggers are created for the replicated articles. The problem is that the triggers are set to ANSI_NULLS ON. This is important for performance that it is the same setting as the database.
We have tried to set ANSI_NULLS OFF in the create replication script, but with no success. Can't find any properties either.
How to do that, other then changing manually afterwards?

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 05/26/2013 :  11:22:19  Show Profile  Visit russell's Homepage  Reply with Quote
It won't affect performance.

Also, be caareful...from BOL
quote:
In a future version of SQL Server, ANSI_NULLS will always be ON and any applications that explicitly set the option to OFF will generate an error. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000