Calling procedure / trigger
-
Hi all,
I'm *pretty* sure this is not possible, but:
Sproc A affects Table B which has Trigger C which calls Sproc D
From within Sproc D, can I find out programmatically that Sproc A is at the head of the stack?
Thanks,
Paul
-
my first thought is that trigger c would not even know how table b was affected, only that it had an event to execute from.
table b could have been affected via either a manual sql statement or executing proc a, the trigger would not care either way and i do not believe even knows.
with that being said, there would be no way for proc d to know about proc a.
-
There are a couple of possibilities that I know of.
Yousef Ekhtiari wrote a great article about using
CONEXT_INFO
to acomplish something like that (http://www.sqlservercentral.com/columnists/yEkhtiari/2765.asp).
You can also query
DBCC INPUTBUFFER
There is a good example on how to implement it here:
http://vyaskn.tripod.com/tracking_sql_statements_by_triggers.htm
Essentially what this will do is tell you what the original TSQL statement was.
Good Luck!
SQL guy and Houston Magician
-
good information to know. thanks robert
-
Robert,
Another good day, I learned something new (and useful).
Thanks!!
P
-
Anytime! Glad I could help
SQL guy and Houston Magician
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply