How to disable a check constraint for replication in SQL server

Developers can explicitly disable check constraints for replication, which can be useful if they are publishing data from a previous version of SQL Server. In this case developers should follow the next steps:

1. In Object Explorer, expand the table with the constraint they want to modify, and then expand the Constraints folder.

2. Right-click the constraint and then click Design (Modify in SP1 or earlier).

3. In the Check Constraints dialog box, select a value of No for Enforce For Replication.

4. Click Close.