Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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
 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  
 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.08 seconds. Powered By: Snitz Forums 2000