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?
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.