Disable constraints/triggers in SQL Server to populate with seed data and re-enable

I have an atypical scenario. I am designing a small new SQL Server database with general elements of a typical relational design. Let us say, this includes a good dose of PK, FK, check constraints and triggers. Once I have the shell of the database ready (with no data), now comes the difficult part: I …

Advertisement