O'Reilly logo

Pro SQL Server Administration by Peter A Carter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 24

image

Triggers

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required