http://www.sqlservercentral.com/Content tagged trigger posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)When a value is changed that causes an error, finding what caused the error can be tricky. Here an application was truncating a column. The trigger helped to identify the culprit.http://www.sqlservercentral.com/scripts/trigger/63736/2008/07/17http://www.sqlservercentral.com/scripts/trigger/63736/This script generates a audit trigger for each table in the database. The trigger then logs when each table is updated.http://www.sqlservercentral.com/scripts/trigger/63064/2008/06/12http://www.sqlservercentral.com/scripts/trigger/63064/Create journal to audit changes in user tablehttp://www.sqlservercentral.com/scripts/journal/61303/2007/12/12http://www.sqlservercentral.com/scripts/journal/61303/