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
Showing posts with label hide. Show all posts
Showing posts with label hide. Show all posts
Sunday, 27 September 2009
Subscribe to:
Posts (Atom)