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.
| Author |
Topic |
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-10-09 : 17:46:49
|
| Why do processes that one kills through theenterprise 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. |
 |
|
|
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? |
 |
|
|
dtomyn
Starting Member
2 Posts |
Posted - 2002-10-09 : 18:14:29
|
| Try using sp_who2 instead |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-10-09 : 18:36:17
|
| Thank you guys. |
 |
|
|
|
|
|