Monday, February 27, 2012

How can I get the ProcessID of a give stored procedure call?

Hello!

How can I get the ID of the process a given stored procedure call belongs to? I want to make some like this:

create procedure P1

as

declare ProcID numeric
set ProcID=SomeFunction()

insert into T1 values (ProcID, ...)

GO

Thanks a lot.Try @.@.spid

No comments:

Post a Comment