Home > Archive > MS SQL Server Connectivity > February 2006 > Quick search for servers I can connect to?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Quick search for servers I can connect to?
Tom D

2006-02-07, 9:23 am

I am using SqlDMO in vb.net to get a list of all the available servers on my
network. I then want to loop through them (all 280) to see which I can
connect to? I've tried looping through them and building a connection for
each to test, but it takes forever even when I set the timeout to 1 second.
Does anyone have any suggestions?

Thanks.
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com