http://www.sqlservercentral.com/Content tagged Auditing, T-SQL posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Auditing data changes in your production environment is very important, especially if you are dealing with confidential information.http://www.sqlservercentral.com/redirect/articles/64669/2008/10/23http://www.sqlservercentral.com/redirect/articles/64669/SQL Server 2005 introduces the OUTPUT clause, a bit of magic that allows us to get the identity value, plus a number of other values, from an INSERT, UPDATE, or DELETE, which all have different interaction with OUTPUT. This article concentrates on INSERT.http://www.sqlservercentral.com/redirect/articles/63892/2008/08/04http://www.sqlservercentral.com/redirect/articles/63892/