|
Home > Archive > MS SQL Server > October 2006 > ListAvailableSQLServers not refreshing (VB-Sql server 2000)
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 |
ListAvailableSQLServers not refreshing (VB-Sql server 2000)
|
|
| areejan2000@yahoo.com 2006-10-24, 6:33 pm |
| i have 3 Sql server2000 servers running on a network
by using SQLDMO (ListAvailableSQLSer
vers ) from another pc where
only Sql client is installed
and the list of all servers are avilable.
but when one of the server is down or shut down , the list is not
refreshed and giving error
how to the refresh the server list with out restarting . ping is
another option , but a connection object is
necessary for that.
| |
| Hilary Cotter 2006-10-24, 6:33 pm |
| ListAvailableSQLServ
ers consults the local domain browser or master domain
brower for a list of SQL Servers which are registered with it. It may or may
not be current, and it doesn't track active (or running) SQL Servers. You
would need something like ODBC ping for that. ping does not require a
connection object, but if you are trying to make a connection with SQL
Server, you will need a connection object (the connect method of
SQLDMO.SQLServer)
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<areejan2000@yahoo.com> wrote in message
news:1159790536.490769.143470@m7g2000cwm.googlegroups.com...
>i have 3 Sql server2000 servers running on a network
> by using SQLDMO (ListAvailableSQLSer
vers ) from another pc where
> only Sql client is installed
>
>
>
> and the list of all servers are avilable.
>
> but when one of the server is down or shut down , the list is not
> refreshed and giving error
>
> how to the refresh the server list with out restarting . ping is
> another option , but a connection object is
>
> necessary for that.
>
|
|
|
|
|