https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Audit-Trail/m-p/5105#M430 Hello!<BR /> <BR /> I am thinking about implementing an audit trail on MySQL which would work with triggers. Does somebody know if the triggers work when I do an SQL update/insert/delete statement directly from SAS to MySQL? <BR /> <BR /> Thanks! Wed, 17 Oct 2007 10:56:16 GMT JuanVte 2007-10-17T10:56:16Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Audit-Trail/m-p/5105#M430 Hello!<BR /> <BR /> I am thinking about implementing an audit trail on MySQL which would work with triggers. Does somebody know if the triggers work when I do an SQL update/insert/delete statement directly from SAS to MySQL? <BR /> <BR /> Thanks! Wed, 17 Oct 2007 10:56:16 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Audit-Trail/m-p/5105#M430 JuanVte 2007-10-17T10:56:16Z https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Audit-Trail/m-p/5106#M431 They should, but you may want to consider doing the audit trail a different way as triggers can slow down your performance significantly.<BR /> <BR /> If you can grab the audit information (userID, date, etc...) prior to doing the insert/update, then you could put that information into the SQL statement and not rely on the database to do the work. Mon, 28 Jan 2008 22:38:41 GMT https://communities.sas.com/t5/SAS-Health-and-Life-Sciences/Audit-Trail/m-p/5106#M431 JasonDiVirgilio 2008-01-28T22:38:41Z