Enterprise Manager

• NickRice

  SSC Veteran

  Points: 205

  More actions

  September 13, 2003 at 9:34 am

  #82945

  Hi Guys,

  Is there a way to set a default database for a server registration? I'm with a shared host and clicking my web hosts server entry in Enterprise Manager lists all the databases (for all the shared hosting customers) on the server, which takes a few minutes of waiting. Maybe there's a way to set one default database for the server registration so that when I click the server entry it connects to the server and lists only the default (my) database.

  Any ideas?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736504

  More actions

  September 13, 2003 at 10:44 am

  #474054

  Not in Enterprise Manager. You can for the login and if they use QA and the Object Browser, they should get better performance.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

  http://www.dkranch.net