O'Reilly logo

SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond by Tom Carpenter

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

Using Triggers

Now for the fun part: using triggers. How can a DBA use triggers to make her job easier? Wouldn't it be cost effective if you could hire an administrative assistant that costs nothing each hour, but works around the clock? That's exactly what you get when you use triggers.

With triggers, you can take automatic action that you've taken manually in the past. If you have any alerts that require your intervention, however, you should look at them closely to determine how to proceed and answer these questions. Can the actions you would take in response to these alerts be automated in T-SQL code? If they can be automated, is the event a DDL or DML event? If the answer is yes to both, then you can use triggers as unpaid assistants.

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