SQL Server Performance

Merge Replication on SQL 2K

Discussion in 'Performance Tuning for SQL Server Replication' started by nilayt, Jul 8, 2003.

  1. nilayt New Member

    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
  2. satya Moderator

    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

Share This Page