Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sp_helpdb and sys.databases inconsistent for user_access Expand / Collapse
Author
Message
Posted Monday, October 29, 2012 7:49 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 10, 2013 8:54 AM
Points: 87, Visits: 253
The 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 interest
The 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?

Thanks
Post #1378252
Posted Tuesday, December 18, 2012 5:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 2:25 AM
Points: 217, Visits: 521
Do 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?
Post #1397732
Posted Tuesday, February 11, 2014 12:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 5:27 AM
Points: 1, Visits: 21
one of my peers is reporting the same situation on one of our servers. 2005.
Post #1540395
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse