Tuesday, June 12, 2007

SQL Server 2000 Hiding System Database and Objects in Enterprise Manager

Simple:

  • Open Enterprise Manager
  • Right Click server registration and click Edit SQL Server Registration properties


  • Uncheck Show system databases and system objects option.
  • Click OK