Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have software that during the installation or updates it drop and adds all of its views, triggers, and stored procedures. This became a problem when we tried to implement a snap shot replication on two SQL Server 2008 R2 Standard machines. Setting up the repication was fine, but during the update process Replication stopped the update because it wouldn't let go of the stored procedures that it was replicating (sorry, I don't have the error handy, I will try to post it later).

My question is, can replication work in an environment where the various pieces of the database are changing frequently? We sometimes will change our table structure, but only to add columns. Our installer does not drop tables though, it only drops the views, triggers, and SPs.

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.