I thought maybe we could do this with EVENTINFO() in a trigger, but the calling proc isn't included in the schema (would be nice!).

Looking at the docs, it seems maybe you could use context info more pervasively in a system and then do something like this:

SELECT context_info AS MyCtxInfo

FROM

sys.dm_exec_requests

WHERE

session_id = @@SPID

AND request_id = CURRENT_REQUEST_ID();

... ? but I am not sure, I don't understand how CURRENT_REQUEST_ID() works or whether you will ever see more than one result from the above code. 

Anyone??

>L<