SQL 2005 Client, Registered Servers Auto-Connect 2

[Ovatvvon]

In the Registered Servers window in Management Studio, all registered servers auto-connect (i.e. green arrow). Is there a way to change the setting so it will only connect if I select it, rather than connecting all of them? (I can't find where to change that setting).

-Ovatvvon :-Q

 

[mrdenny]

If it's the registered server list it's not connecting to SQL, it's checking the service status via windows.

Until you open a query or the object explorer you aren't actually making a connection to the SQL Service.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Ovatvvon]

Do those polls impact server performance? Or are they pretty "light-weight"?


-Ovatvvon :-Q

 

[onpnt]

No. They do not impact performance unless there is some sort of malicious attack utilizing that type of request



[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[mrdenny]

It's simply a WMI call to the remote OS which uses RPC. This is standard Windows stuff. You could through 100,000 WMI calls at a time to a server and probably not feel it.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Ovatvvon]

Nice. Great information. Thanks!


-Ovatvvon :-Q