SQL Server Performance Forum – Threads Archive
Merge Replication on SQL 2KHello, 1> While generating Intial snapshot all scripts are
keeping SET Quoted_Identifiers ON where my default setting
is OFF and I want to keep it OFF…How can I do it for
Replication. 2> If I’m changing one SP on a Database what is easiest
way to handle for replication. Thanks
Those SET options has to be setup while using those scripts, and are affective for that session.
In general REPLICATION will take care of such changes and if any schema changes occurred on the database, the best option is to restore database for any mismatches. HTH _________