By tag: Auditing
0
kicks
SQL 2005 Auditing With Triggers Using XML
Implementing trigger-based data auditing in SQL 2005 using the XML datatype to store the audited data.
0
kicks
When was a SQL Server table or view last altered?
A very handy little script to determine the last time a SQL Server table or view was altered.
0
kicks
SQL Server: How to audit rollback-ed data in a trigger?
The most popular method of auditing data is with an AFTER DELETE, INSERT, UPDATE trigger.
But what happens if you have a Rollback statement in your trigger if some condition is met?
<br><br>
More ><a href="http://weblogs.sqlteam.com/mladenp/archive/2007/04/13/60174.aspx&q...