Hide System Tables and Objects in MS SQL Enterprise Manager

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:

  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.”
Share the Post:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: