May 20, 2009 at 12:34 am
how can i know pc or userid from spid?
May 20, 2009 at 12:42 am
how you will find SPID?
check the hostname column...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2009 at 12:44 am
Here are 2 ways of doing so (just replace the value 51 with the real value):
select hostname, loginame from sys.sysprocesses where spid = 51
select host_name, login_name from sys.dm_exec_sessions where session_id = 51
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 20, 2009 at 1:29 am
Ok.
Its works.........
Thanks all
May 20, 2009 at 6:18 am
😀
[font="Comic Sans MS"]+++BLADE+++[/font]:cool:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply