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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-24 : 21:44:09
|
| Henry writes "How do I totally remove an orphaned session that has an unknown blocking spid? When I try to kill an orphan session I see a the status as Killed/Rollback. But the Block By column shows only a period mark, thereby not showing an actual spid number. Tables and stored proceudres, used in the troubleshooting so far are: syslockinfo, sysprocesses, sp_who2,sp_lock on SQL 2000 service pack 1. I used the kill command to delete remove the orphan session. Don't want to restart service, because from past experience restart did not resolve the issue." |
|
|
|
|
|
Killing Orphaned Sessions