Friday 19 April 2013

Hide System Objects in Object Explorer in SQL Server Management Studio

By default you can see SQL Server system objects using SQL Server Management Studio.
In the Databases node of Object Explorer, System Databases are shown:

System Stored Procedures are shown also:

To hide system objects in Object Explorer, in SQL Server Management Studio:
click Tools -> Options

Click: Environment

select Hide system objects in Object Explorer -> click OK:

SQL Server Management Studio must be restarted for this change to take effect:

After you close and reopen SQL Server Management Studio, System Databases are not shown:

System Stored Procedures are also not shown:

System functions are not affected by this setting:

System data types are also not affected by this setting:

No comments:

Post a Comment