Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Viewing Master Db in MMC

Status
Not open for further replies.
Hush

Hush

Technical User
Dec 20, 2000
6
GB
So I thought I was clever and removed my ability to view system type databases in the Management console, of course now when I want to see things in the master database I can't...

How do I return to the Halcyon days of viewing everything?
 
Sort by date Sort by votes
It sounds as if you're using SQL Server Enterprise Manager. Is that right? If so, you can resume seeing the system databases by right clicking on the server. Then you will see an option to "edit SQL Server registration properties". Select that, and on the resulting general tab, make sure that the "Show system databases and system objects" box is checked.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mmiah1982
  • Locked
  • Question
Extracting mutiple data items from DB with JSON string format column
Replies
2
Views
127
mmiah1982
mmiah1982
BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
139
carp
carp
BobThornton
  • Locked
  • Question
Cross Join in an Insert Into
Replies
1
Views
142
carp
carp
harfri
  • Locked
  • Question
Insert into a new table
Replies
0
Views
88
harfri
harfri
NickyJay
  • Locked
  • Question
SQL 2008 exclude parent records in results where multiple child records exist in 2nd table
Replies
4
Views
125
PHV
PHV

Part and Inventory Search

Sponsor

Back
Top