[dba-SQLServer] SQL Server 2005 Update Trigger

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