Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Well, OK. Make it an answer if you want the rep. – Sacha K May 2 '13 at 13:27
I can't reproduce this on SQL Server 2012 Standard SP1... – gbn May 2 '13 at 14:15
Are you using Management Studio or Management Studio Express? As of SP1 Management Studio is now completely free (so you'll have full SSMS functionality and you won't be hampered by this bug). – Aaron Bertrand May 2 '13 at 14:41
I have SP1 installed. If I run an installer (Standard Edition) and select add features it shows both Management Tools - Basic and Management Tools - Complete as already installed. Doesn't say Express anywhere in SSMS. – Sacha K May 3 '13 at 8:26
up vote 3 down vote accepted

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.