Did you know that the System databases and objects can be hidden in SQL Server Management Studio?
This is not a new feature though. The option to hide system databases and objects was present in SQL Server 2000 as well.
Before Hiding
Procedure To Hide:
This is not a new feature though. The option to hide system databases and objects was present in SQL Server 2000 as well.
Before Hiding
- Open SQL Server Management Studio (SSMS)
- Click "Tools" and Choose "Options"
- Expand "Environment" and click on "General"
- Select the Check box "Hide System objects in Object Explorer"
- Click "OK"
- For the changes to take effect, you have to restart the SQL Server Management Studio
- Close and reopen the SQL Server Management Studio.
After Hiding:
3 comments:
Nice.. In SQL Server 2012, Tools -> Environment -> Startup -> Hide..
Can you hidden the folders?
Can you hidden the folders?
Post a Comment