Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.