SQL Server 2008 hides system objects in Object Explorer

Environment: SQL Server 2008 R2

Problem: Hiding system objects in Object Explorer

Solve:

The database node of Object Explorer contains system objects, such as system databases. Use the Tools/Options page to hide system objects. Some system objects, such as system functions and system data types, are not affected by this setting.

Hide System objects in Object Explorer

1. On the Tools menu, click Options.

2. On the Environment/General page, select Hide System Objects in Object Explorer, and then click OK.

3. In the SQL Servermanagement Studio dialog box, click OK to confirm that you must restart SQL Server Management Studio for this change to take effect.

4. Close and reopen SQL servermanagement Studio.