Viewing 3 posts - 1 through 3 (of 3 total)
Please check the following link for whole list of fixes.
http://sqlserverbuilds.blogspot.com/
July 25, 2011 at 6:42 am
#1357725
I guess the issue was first open from SQL Server 7.0, but SQL 2005 for emergency mode you have to execute:
alter database mydb
set emergency
go
You don't need to restart SQL Server Service...
August 1, 2007 at 8:10 am
#723874
You can execute sp_lock.
January 17, 2007 at 11:29 am
#683814