Blog Archives

DDL Triggers for SQL Server 2005

Today I will discuss about DDL Triggers which is the new feature added in SQL Server 2005. Microsoft SQL Server 2005 provides two primary mechanisms for enforcing business rules and data integrity: constraints and triggers. A trigger is a special

Posted in Microsoft Technology Tagged with:

Disabling Constraints and Triggers

Constraints are valuable tools for maintaining data integrity in databases. However, there are times when it is convenient to disable one or more of them to perform tasks such as data synchronization with an offline database. When SQL Serverâ„¢ replication

Posted in Microsoft Technology Tagged with: