Monday, March 26, 2012

Making changes to a DB with Replication

Hi,
What is the best method/model for having real time replication set up and also needing the ability to drop and recreate SP's/Tables/UDF's etc? I keep getting the error of the SP is being used in replication so it cannot be dropped...
Thanks in advance.
AdamThe best method/model is not to introduce structural changes to replicated articles. The fact that you have a need for it tells me that the app design is not thought through, and needs to be changed.

No comments:

Post a Comment