sp_helpdb and sys.databases inconsistent for user

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » Data Corruption (SS2K8 / SS2K8 R2) » sp_helpdb and sys.databases inconsistent for...

sp_helpdb and sys.databases inconsistent for user_access

Rate Topic

Display Mode

Topic Options

Author

Message

mister boom

Posted Monday, October 29, 2012 7:49 AM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, January 04, 2013 3:40 AM
Points: 87, Visits: 248

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

Aeterna

Posted Tuesday, December 18, 2012 5:54 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:29 AM
Points: 214, Visits: 402

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

« Prev Topic | Next Topic »

Permissions