Merge Replication on SQL 2K | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Merge Replication on SQL 2K

Hello, 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
Nilay
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 _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>