Recently I have been working with SQL tables and stored procedures in Enterprise Manager. By default, the system and stored procedures are visible along with user-defined ones which make it fairly inconvenient when you are only interested in your own tables and stored procedures.
To make life a bit easier I thought I would find a way of hiding the system objects. The instructions are as follows :
1. Right click on the "(Local)(WindowsNT)" in the Enterprise Manager.
2. Select "Edit SQL Server Registration Properties," which opens up a property panel.
3. Uncheck the option "Show system databases and system obejcts."
4. Click OK
No comments:
Post a Comment