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

Neil Pike

March 4, 1999

1 Min Read
ITPro Today logo in a gray background | ITPro Today

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

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"

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like