June 10, 2003 at 1:56 pm
I already have merge replication setup for tables and that works fine. I want to replicate stored procedures now. Has anyone ever done this? What are the best practices? What should I watch out for?
Thanks in advance,
Mike
June 10, 2003 at 2:24 pm
Do you want to replicate the schema or the execution of the stored procedures?
June 10, 2003 at 2:31 pm
I want to replicate the schema to all my other servers. I only want to change the stored proc at one server (publisher).
June 11, 2003 at 3:50 pm
Well then there isn't much to say then. It is not difficult. I would create them in a new publication, because when you change the stored procedure, iw will not replicate the changes. So you will have to drop and re create the publication.
Or you can also execute sp_addscriptexec (Check in BOL) by adding the sp to a .sql script and then delivered to all the subscribers with this sp.
It will be executed each time to merge agent starts.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply