R, can you reference the @@PROCID global variable in the INSERT statement within the trigger?
INSERT INTO <logtable>
(
<stuff>,
SprocName,
<morestuff>
)
VALUES (
<stuff>,
OBJECT_NAME(@@PROCID),
<morestuff>
)
SJTerrill
P.S. I'm wondering if there's another, perhaps more easily managed, method to perform this trick. Perhaps a stored proc that gets called from within your stored procs that perform these tasks... and pass that proc the current OBJECT_NAME(@@PROCID) value. I'd be interested in what the resident gurus think!