Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 kill

Author  Topic 

carumuga
Posting Yak Master

174 Posts

Posted - 2009-10-23 : 09:05:30
Hi,

I'm killing one of the session/process that is being blocked by other process using KILL command and its obvious that other user who is running the blocked process will get affected. Is there a way where the user can track the process id of the user who executed the kill command.

Thanks in advance!!!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-10-23 : 09:10:02
sp_who2



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page
   

- Advertisement -