Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 alter procedure in merge replication

Author  Topic 

dejjan
Yak Posting Veteran

99 Posts

Posted - 2006-07-21 : 08:57:57
Hello,
how could I alter procedure on publisher side and to replicate it to subscribers.
I tried simply to alter procedure but nothing happens on subscribers.


Thanks in advance

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-07-24 : 22:49:38
are the procedures set to replicate also?
is the replication immediate? it might be scheduled

--------------------
keeping it simple...
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-07-25 : 00:49:55
you will need to re-initialize the subscription for the changes to be propagated.

You should probably have your code split out in a separate publication from your data so that you can re-initialize it whenever you want.


-js
Go to Top of Page
   

- Advertisement -