May 24, 2012 at 10:38 am
I have a procedure on a server which can be called from several different linked servers. (To be precise, the server on which the procedure exists has been set up as a linked server on the various source servers.) Whenever it's called, I want to identify the calling system in a log without it being passed as a parameter (no spoofing allowed).
@@REMSERVER appeared to be the answer to a maiden's prayer, but it has apparently been deprecated. Five minutes of searching MSDN and I can't find any sort of alternative. Suggestions?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 24, 2012 at 11:15 am
Would culling the information from sys.dm_exec_connections/dm_exec_sessions be acceptable?
May 24, 2012 at 11:38 am
Let me test it and see. Thanks, Ben!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply