[dba-SQLServer] SQL Server 2005 Update Trigger

Paul Hartland paul.hartland at googlemail.com
Fri Oct 2 03:29:20 CDT 2009


To all,

Only really done very basic work with triggers on SQL Server, I have an
audit table where the trigger will records updates to & a table where if a
certain column gets updated the trigger will fire, and record on the audit
table.

Is there anyway I can get the name of the stored procedure or the
application that caused the update so that I can also log this in my audit
table.

Thank you in advance for any help on this.

-- 
Paul Hartland
paul.hartland at googlemail.com



More information about the dba-SQLServer mailing list