SQL Server supports three types of triggers. The first type is made up of DDL (data definition language) triggers, which fire in response to a DDL statement being executed, such as CREATE, ALTER, or DROP. You can use DDL triggers for auditing or for limiting DBA activity. The second type, logon triggers, fire when a session to the instance is established. You can use these triggers to stop a user from establishing a connection to an instance. The final type, DML triggers, fire as a result of a DML (data manipulation language) statement being executed, such as an INSERT, UPDATE, or DELETE statement. Developers use DML triggers ...

Get Pro SQL Server Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.