Hide System databases and objects | SansSQL

Sunday, February 24, 2013

Hide System databases and objects

Did you know that the System databases and objects can be hidden in SQL Server Management Studio?
This is not a new feature though. The option to hide system databases and objects was present in SQL Server 2000 as well.
Before Hiding

Procedure To Hide:
  1. Open SQL Server Management Studio (SSMS)
  2. Click "Tools" and Choose "Options"
  3. Expand "Environment" and click on "General"
  4. Select the Check box "Hide System objects in Object Explorer"
  5. Click "OK"
  6. For the changes to take effect, you have to restart the SQL Server Management Studio
  7. Close and reopen the SQL Server Management Studio.
After Hiding:

3 comments:

Suresh said...

Nice.. In SQL Server 2012, Tools -> Environment -> Startup -> Hide..

Alfonso Vargas said...

Can you hidden the folders?

Alfonso Vargas said...

Can you hidden the folders?

Post a Comment