ListAvailableSQLServers Method

SQL-DMO

SQL-DMO

ListAvailableSQLServers Method

The ListAvailableSQLServers method returns a NameList object that enumerates network-visible instances of Microsoft® SQL Server™ 2000.

Applies To
Application Object
Syntax

object.ListAvailableSQLServers( ) as NameList

Parts

object

Expression that evaluates to an object in the Applies To list

Prototype (C/C++)

HRESULT ListAvailableSQLServers(
LPSQLDMONAMELIST* ppServerNames);

Returns

A NameList object that enumerates instances of SQL Server.

Remarks

Nondefault instances of SQL Server are displayed in the form of SERVERNAME/INSTANCENAME.

The ListAvailableSQLServers method is supported only for servers and workstations running Microsoft Windows NT® 4.0 and Microsoft Windows 2000.

Note  ListAvailableSQLServers maps to the ODBC SQLBrowseConnect function, which does not support connection pooling. Therefore, an application that enables connection pooling might encounter the error "Microsoft SQL-DMO (0x800A000E) [SQL-DMO]Not enough storage is available to complete this operation." when calling ListAvailableSQLServers.