Home Forums SQL Server 2005 T-SQL (SS2K5) database stuck in single user and no spid RE: database stuck in single user and no spid
Nils Gustav Stråbø
SSChampion
Points: 11259
More actions
September 21, 2012 at 11:07 am
#1540866
You can also see who is holding a lock on the database by querying sys.dm_tran_locks.
Kill the session_id and change to multi user by executing ALTER DATABASE db SET MULTI_USER.