Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
timoqvist
Starting Member
8 Posts |
 Posted - 2006-09-29 : 05:05:50
|
| Hi!Short version:In the body of a trigger, ins/del/upd whichever, is there a system variable, like @@trancount for instance, that gives me the name or object id of the SP that caused the trigger to fire?What I'm trying to accomplish is to append an existing log which saves information about ins/del/upd on a table with time/user/etc with the actual *name* of the SP which caused the log. If not, anyone of you guys wanted the same thing and solved it somehow?ThanksT |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-29 : 05:45:55
|
| I think the only way to figure out, is to add audit functionality on your SPs.Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
Trigger Question