Home Dashboard Directory Help
Search

Removing a article from Transactional replication does not drop triggers and constraints by AIM48


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 811795
Opened: 12/17/2013 6:30:52 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

When you add a table to a updateable transactional replication publication- and then later drop it (I experienced this via the properties dialog box).
Sql server does not remove all off the replication related stuff that it left on the subscriber - specifically the update triggers - and more importantly the Identity Range Constraints

This ended up hurting us because we hit this constraint in middle of the night without even realizing it was still there
Details
Sign in to post a comment.
Sign in to post a workaround.