InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 22:12:58 GMT20http://www.sqlservercentral.com/Forums/Topic1378252-2893-1.aspxDo you know what versions the two instances are? For example, one being 2008 and the other 2008 R2? Or are there any discrepancies between the service packs?Tue, 18 Dec 2012 05:54:23 GMTAeternahttp://www.sqlservercentral.com/Forums/Topic1378252-2893-1.aspxThe Master database on one of our servers is showing in SSMS as Single-user mode. I have tried to change it back to multi-user, but am getting error "Option 'MULTI_USER' cannot be set in database 'master'". Weirdly, I am able to connect to the database and make changes to it.Sys.databases is reporting user_access as 'SINGLE_USER'However, sp_helpdb 'master' reports "user_access=MULTI_USER"DBCC CHECKDB returns nothing of interestThe error logs all look fine, too.I understand that another instance of SQL Server was installed on the same server recently, though that is used by another department, and I don't have access to that instance. Could this have caused this confusion?Our infrastructure providers are saying that this inconsistency is only a GUI issue, so we shouldn't be concerned. However, I am concerned that this could be indicative of a wider problem with the database and that they are trying to sweep it under the carpet.Can anyone shed any light on these inconsistencies?ThanksMon, 29 Oct 2012 07:49:02 GMTmister boom