Apr 21, 2012

Exploring SSMS - Hiding System databases

 In this post we will see how to know to hide system databases from the SQL Server management studio.

In the Tool bar, goto Tools-->Options. Then Under Environment click on Startup. On the right of the windows Check the option labelled as Hide system objects in Object Explorer. If you want to bring them back to object explorer, follow the same procedure and uncheck that option

Note: You have to restart the SSMS to see the changes.

No comments:

Post a Comment


Thanks for your visit to this blog.
We would be happy with your Queries/Suggestions.