Why can't I see master, msdb etc. in SQL 7 EM? Also I can't see the system tables in user databases.

A. The reason for this is that by default system objects are not viewable.

To fix this, right click on the server name in Enterprise Manager and select "Edit SQL Server Registration Properties". Check the box to "show system databases and objects"


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish