Wednesday, September 26, 2012

SQL Error 924 Database Single User mode change to Multi Users mode

exec sp_lock --- find the spid by dbid with lockType X Kill spid ----- kill the Spid exec sp_who --- find the Spid Kill spid ----- kill the Spid again ALTER DATABASE EmailXtender Set MULTI_USER

No comments:

Post a Comment