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.
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond 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.
