As you know I have started a new series on "Exploring SSMS" by which I will be posting some features that are available in SSMS which will be very helping during the development. 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 optionNote: You have to restart the SSMS to see the changes.
Other posts that come under Exploring SSMSEnabling Save ChangesEnable/disable intellisenseConnecting to msdn forums or submitting your feedback to connectFiltering object namesChanging Top N rows valuesCopy results with header
Tags: t-sql, sql_server, sqlserver, tsql, SSMS,