Unkillable SPID's - SQL Server Forums

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 Administration (2000)

Unkillable SPID's

Author

Topic

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2001-06-11 : 09:42:02

Last week I ran into an orphaned, unkillable SPID. The SPID was holding a table lock on one of our most important tables, so our morning processes were held up while trying to truncate the table and recreate it. I traced the SPID back to a Brio query that locked up our Brio admins workstation. She rebooted and SQL Server 7 didnt drop the SPID

. I tried to kill the SPID from T-SQL, SQL EM, and DBArtisan. Nothing worked

. I finally stopped and restarted the SQL Services and the SPID was gone

. Has anyone else ran into an unkillable SPID?

Daniel
SQL Server DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources