Monday, March 19, 2012

ListAvailableSQLServers (SQLDMO) not up to date

Hi NG,
MSSQL2k+SP3a+MDAC2.8
If I use ListAvailableSQLServers (SQLDMO)
I get after 2 or 3 seconds a Serverlist.
But the serverlist is not up to date.
Thats means a server which shut down 20 seconds before
apperas in the serverlist. A server which started 20 seconds before
dont show in the list.
Thanks ThomasHi
As far as I can tell, the list is cached for a short time to help with
network performance. You will have to experiment to find the exact
timeframe.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Thomas Hase" <tohas@.freenet.de> wrote in message
news:42302c73.366146156@.news.t-online.de...
> Hi NG,
> MSSQL2k+SP3a+MDAC2.8
> If I use ListAvailableSQLServers (SQLDMO)
> I get after 2 or 3 seconds a Serverlist.
> But the serverlist is not up to date.
> Thats means a server which shut down 20 seconds before
> apperas in the serverlist. A server which started 20 seconds before
> dont show in the list.
> Thanks Thomas

No comments:

Post a Comment