InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 04:33:07 GMT20http://www.sqlservercentral.com/Forums/Topic1189873-391-1.aspxRun this in SSMSUSE yourDBGO 1000When the command succeeeds you will be able to put the db back into multi user mode.http://blogs.msdn.com/b/dfurman/archive/2012/01/20/getting-out-of-single-user-mode.aspxTue, 04 Dec 2012 04:50:48 GMTTerence Keyshttp://www.sqlservercentral.com/Forums/Topic1189873-391-1.aspxI have the same problem and mystery jumbo may be right but i can not even check sp_who2 to find who has a open connection, what to do?Tue, 04 Dec 2012 03:26:40 GMTTara-1044200http://www.sqlservercentral.com/Forums/Topic1189873-391-1.aspxThanks MysteryJimbo! That fixed my problem!!!!!Thu, 13 Oct 2011 09:29:04 GMTjillkhttp://www.sqlservercentral.com/Forums/Topic1189873-391-1.aspxYou can check for open connections to the database through Activity Monitor or using sp_who2 through a query window. You can kill open connections to the database using the kill command. Once there are no connections to the database you should be able to make the change.It is possible that another connection is using the database using 3 part naming through another database so bear that in mindThu, 13 Oct 2011 09:08:25 GMTMysteryJimbohttp://www.sqlservercentral.com/Forums/Topic1189873-391-1.aspxCan you access it via a connection window? (Where you type queries and all that.)If so:[code="sql"]alter database MyDatabaseName set multi_user;[/code]Thu, 13 Oct 2011 08:27:31 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic1189873-391-1.aspxI changed a database to Single User mode in SSMS and now I cannot change it back to Multi User mode. When I click to view the Properties of the database to change it, I get the message: "Database is already open and can only have one user at a time (Microsoft SQL Server, Error: 924)"How can I get it switched back to Multi User mode?Thanks!Thu, 13 Oct 2011 08:13:46 GMTjillk