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.
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
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"
About the Author
You May Also Like
.png?width=700&auto=webp&quality=80&disable=upscale)