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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can anyone tell me how to enableªdisable the display of the Master, Model, and Tempdb databases in Enterprise Manager?

Enterprise Manager

Can anyone tell me how to enableªdisable the display of the Master, Model, and Tempdb databases in Enterprise Manager?

by  ecobb  Posted    (Edited  )
In Ent. Manager, Right click on the Server and select "Edit SQL Server Registration Properties". In the window that pops up, there will be 3 check boxes at the bottom. The middle box will say "Show system databases and system objects", check it to show Master, Model, etc..., and uncheck it to hide them.
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top