October 8, 2009 at 9:08 am
I have a fairly massive transactional publication that contains a stored procedure that I need to edit. I know that when I change it that the change will not get pushed out to the subscriber databases. Is their anyway other then reinitializing this publication to push that change out?
Would modifying the stored procedure on the subscriber databases to match the stored procedure on the publisher cause any issues?
October 8, 2009 at 2:17 pm
You cannot replicated stored procedures if you are using SQL 2000. (From my knowledge atleast) So feel free to change the stored proc in the production, script it and run it in subscriber.
Dont try to mark it for reinitialization. But test it out in your test environment before you do it in production.
-Roy
October 8, 2009 at 10:35 pm
Having you consider creating a snapshot publication that contains just stored procedures ?
You can then just re-initialise this publication as required
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply