SQL Server Performance

Changing stored procedure or trigger in Merge rep

Discussion in 'Performance Tuning for SQL Server Replication' started by nilayt, Sep 18, 2003.

  1. nilayt New Member

    Hello,
    I have set up Merge Replication on SQL2k on Win2k.
    How can change Stored procedure or trigger in Merge
    Replication on Publisher so that it automatically change
    to suscriber? Do I have to run on both (publisher &
    subscriber database)?

    Any help Appreciated

    Thanks
    -Nilay
  2. satya Moderator

    YOu can edit the SP or trigger as normal and it will be affected automatically on both databases.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. nilayt New Member

    No, It doesn't.
  4. satya Moderator

    As you're using SQL 2K the schema changes will be automaticlly updated on publisher and subscriber.
    Check the log or use PROFILER to track the behaviour.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page