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

    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

  2. satya Moderator

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

    Satya SKJ
  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

Share This Page