General discussion

Locked

SQL Replication

By collazo21 ·
Just wondering if you can help me out with something or give me some tips. I am creating a SNAPSHOT and Transactional replication to various sites.



My co-workers don't think it will be possible to put the stored procedures into the Publication because of this: if they need to update the stored procedures with Steve's batch process, they can't be dropped and re-added since they are in the Publication. That generates errors.



Do, you know of any way to automatically pull something out of a Publication temporarily so it can be modified, and then put it back into the Publication? If not I won?t add the Stored Procedure on the publication.





Thanks,





Joel Collazo

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Networks Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums