March 9, 2005 at 8:56 am
I have about 100 databases in SQL Server that I would like to limit which databases are viewed in SQL Server Enterprise Manager. Does Enterprise Manager have a filtering capability which limits the databases that appear in the Tree tab? Is there anyway to group databases so that only selected databases appear in the Tree tab?
Any advice would be appreciated?
March 9, 2005 at 12:34 pm
There is not a way to hide database names in Enterprise Manager. See this earlier thread:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=9669
Greg
Greg
March 9, 2005 at 1:24 pm
Greg,
Thanks for referering me to the thread. My reason for hiding databases is simply to reduce those databases that are infrequently used. Less chance of selecting the wrong database!
March 10, 2005 at 12:32 am
In the registration properties for a SQL Server you can disable the displaying of the system databases and objects - this is done via the proc sp_MSdbuseraccess, you can look at this proc or run this proc to hide databases.
March 10, 2005 at 10:26 am
You can also group servers in the EM tree. Then you can expand each group or collapse each group. I have groups called 'Dev Servers' and 'Prod Servers'. Right click on the console root in EM and select 'New Sql Server Group...'
Greg
Greg
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy