General discussion


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.


Joel Collazo

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums