Identify and resolve SQL Server problems BEFORE they happen with SQL diagnostic manager

Hiding System Objects in Object Explorer in SQL Server Management Studio

By: Ashish Kumar Mehta | Read Comments (1) | Print Ashish has been contributing to the MSSQLTips.com community since 2009 with over 60 tips. Related Tips: More

Problem

While looking through the new features and improvements in SQL Server Management Studio (SSMS) we found a potentially interesting one to Hide System Objects in Object Explorer in SQL Server Management Studio. In this tip we will take a look at how to Hide System Objects in Object Explorer.

Solution

You may have noticed that once you are connected to a SQL Server Instance using SQL Server Management Studio, in the Databases node of Object Explorer you can see system objects such as the system databases as shown in the snippet below.

You can hide system objects in Object Explorer by following the below mentioned steps:

1. In SQL Server Management Studio, under Tools menu, click Options as shown in the snippet below.

2. In the Options dialog box, expand Environment and then select the General tab as shown in the snippet below. Select Hide system objects in Object Explorer and then click OK.

3. In the Microsoft SQL Server Management Studio dialog box, click OK to acknowledge that the changes will come into effect once you restart SQL Server Management Studio.

4. Next, go ahead and close SQL Server Management Studio. When you reopen SQL Server Management Studio once you are connected to SQL Server Instance you will not see the System Objects in Object Explorer in SQL Server Management Studio as shown in the snippet below.

Next Steps

• Read Using Object Explorer Details and Object Search Feature of SQL Server 2008 Management Studio
• Read Performance Analysis Using SQL Server 2008 Activity Monitor
• Read more tips on SQL Server Management Studio Tips

Related Tips: More | Become a paid author

Last Update: 2/25/2011

Share:

Share

Tweet

Free SQL Server Learning Building Blocks for Your SQL Server Career Database development best practices What Are You Waiting For?

Comments and Feedback:

Thursday, March 03, 2011 - 5:01:11 PM - Tim
Thanks for the tips.  Since I rarely use the system database I'm think I'm going to go ahead and hide them.

Post a Comment or Question

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name

*Email

Notify for updates

Comments *** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SSMS and paste the code into a text editor like NotePad before copying the code below to remove the SSMS formatting.
*Enter Code

 

Sponsor Information

"Amazing, Amazing, Amazing! SQL doctor is truly one of the most powerful tools I have seen." The SQL Developer Bundle - 10 essential tools every database developer needs. Download a free trial. Do you need some help to solve SQL Server problems you are facing? Join the over million SQL Server Professionals who get their issues resolved daily. Free Web Cast - What Are You Waiting For? Delivered by Jason Strate on Wednesday, March 14 @ 3:00 PM EST