New SQL Server Video Tutorial: Part 3 - Building AFTER Triggers for Auditing Row Changes and Table Changes

Part 3 - Building AFTER Triggers for Auditing Row Changes and Table Changes - view details

In this third video in the series, Scott will demonstrate to you how you can build your own AFTER trigger that will audit row changes and table changes. Also included with this video tutorial download is Scott's SQL Script.

Highlights from this video:

• Similarities between Triggers and Stored Procedures
  
• Creating an audit trail trigger
  
• Finding your triggers from the Object Explorer
  
• Can triggers exists for more than one operation?
• How do I know what to JOIN on?
  

and much more

---

• Source: http://www.learnsqlserver.com
• Category: Transact-SQL Basics: Queries, Stored Procedures, Functions and more
• Skill Level: 300 (Intermediate)
• Length: 11:15 (11.5MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: trigger, dml, AFTER, build trigger, audit,