MSDB Stuck in Single User Mode

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  January 20, 2012 at 7:22 am

  #266913

  I had set MSDB on a New machine that is not in production into Single User mode and my session hung so it is stuck.

  I try to set it back to multi_user and of course it is not going to work.

  ALTER DATABASE MSDB SET MULTI_USER

  GO

  Msg 5064, Level 16, State 1, Line 1

  Changes to the state or options of database 'MSDB' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.

  Msg 5069, Level 16, State 1, Line 1

  ALTER DATABASE statement failed.

  Any help would be greatly appreciated.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  January 20, 2012 at 7:25 am

  #1436480

  Never mind I was able to resolve.

  Find the session that put it into single user mode, kill it and set to multi-user mode.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/