Changing stored procedure or trigger in Merge rep | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Changing stored procedure or trigger in Merge rep

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
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
No, It doesn’t.
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
]]>