Hide System Objects in Object Explorer in SQL Server Management Studio
In the Databases node of Object Explorer, System Databases are shown:

System Stored Procedures are shown also:

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