SQL Server 2008 Analysis Services Training Video: Real World Code : Audit Trail Trigger to Store Previous Value in a New Column

Real World Code: Audit Trail Trigger to Store Previous Value in a New Column - view details
Here's a real world example of using an AFTER trigger. Looking at a simple scenario in which users must create new passwords that cannot be the same as their last passwords, Scott points out some tricks and potential complications with using the AFTER trigger.

Highlights from this video:An AFTER trigger in actionUsing a trigger to audit a changeCreating a new triggerHow many times does a trigger fire per batch? Why is this important?The T-SQL JOIN syntax
and much more Source: http://www.learnitfirst.com/Course/161/Video/3009/Audit-1.aspx Course: http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx Skill Level: 300 (Intermediate) Length: 11:30 (26.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: trigger, after, dml, primary key, table, virtual, join, fire, audit, change, syntax

This video comes from the SQL Server 2008 Analysis Services online training course, Transact-SQL Programming: SQL Server 2008/R2. And be sure to check out even more SQL Server Analysis Services training videos.