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 2000 Forums
 SQL Server Development (2000)
 Process Killed Still Shows

Author  Topic 

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2002-10-09 : 17:46:49
Why do processes that one kills through the
enterprise manager show up after you click on kill process.
Shouldn't these go away?



robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-10-09 : 17:48:38
You might have to refresh the window. Or, just use the KILL command in Query Analyzer, then run sp_who to see which SPIDs are still remaining.

Go to Top of Page

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2002-10-09 : 18:09:47
How would I see the application column just like in the enterprise manager?

Go to Top of Page

dtomyn
Starting Member

2 Posts

Posted - 2002-10-09 : 18:14:29
Try using sp_who2 instead

Go to Top of Page

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2002-10-09 : 18:36:17
Thank you guys.

Go to Top of Page
   

- Advertisement -