HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

SSMS 2012 is not showing the tables of the system databases

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
tablesthessms2012showingdatabasessystemnot

Problem

I have SQL Server Management Studio 2012 on my laptop connected to a SQL Server 2012. If I go in System Databases and then any of the 4 (master, model, msdb, tempdb) I don't have the Tables folder.

I'm quite sure it was there in SSMS 2008 R2. Why were the tables hidden? How can I make them visible?

Solution

As per this Connect item it will be fixed in the next major release of SQL Server.

Context

StackExchange Database Administrators Q#41399, answer score: 3

Revisions (0)

No revisions yet.