Transactional Replication on SQL Server 2005 Enterprise x64 (SP3).
I need to add check constraints to a databases that is the target for a replication, but I cannot add the check constraints to the publishing database. The Problem is that the replication process keeps removing my constraints. How do I pr开发者_StackOverflowevent this?
You could create some ddl triggers to prevent the constraint being removed. however replication would fail horribly if you alowed the publishing database to publish data that violated the constraint, which is a distinct posibility if you cannot add the constraint to the master database.
精彩评论