Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aboe
Starting Member
4 Posts |
 Posted - 2013-05-14 : 02:55:22
|
| 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
5072 Posts |
Posted - 2013-05-26 : 11:22:19
|
It won't affect performance.Also, be caareful...from BOLquote:
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.
|
 |
|
|
|
|
|
Merge replication ANSI_NULLS settings