CODEWITHSUNDEEP
sqlsql-server-2008stored-proceduresdiagnostics
Chris Ballance
Chris Ballance

Reputation: 34347

How to identify the caller of a Stored Procedure from within the Sproc

I have a deprecated stored procedure which should no longer be called from code, but there is some system which is still calling it. This is a production server so I have very limited indirect access to it for performing diagnostics.

Is there any way to determine the machine which is calling a particular stored procedure from within the sproc? Something such as @@CallingMachineIP or @@CallingMachineName

Upvotes: 12

Views: 6976

Answers (2)

Brandon
Brandon

Reputation: 14196

@@SPID should give you the current process ID.

Then,

select * from master.dbo.sysprocesses where spid = @@SPID

You can get what you need from one of those columns.

Upvotes: 6

Martin Smith
Martin Smith

Reputation: 453298

select hostname from master..sysprocesses where spid=@@SPID

or 

select host_name from sys.dm_exec_sessions where session_id=@@SPID

Upvotes: 12

Related Questions