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
    nilayt, Sep 18, 2003
    #2

  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
    satya, Sep 19, 2003
    #2

  3. nilayt New Member

    No, It doesn't.
    nilayt, Sep 19, 2003
    #2

  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
    satya, Sep 22, 2003
    #2

Share This Page