Default system tables and stored procedures are visible along with user-defined ones in MS SQL Enterprise Manager. This is fairly inconvenient when you’re trying to walk thorugh your own tables and stored procedures. To hide these system objects, try the following:
- Right click on the “(Local)(WindowsNT)” in the Enterprise Manager.
- Select “Edit Sql Server Registration Properties,” which opens up a property panel.
- Uncheck the option “Show system databases and system obejcts.”
ref: http://www.devx.com/tips/vtBrowser/20528 (Tip bank)