ListAvailableSQLServers Method

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

Syntax

object.ListAvailableSQLServers()asNameList

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.

Note

The ListAvailableSQLServers method maps to the ODBC SQLBrowseConnectfunction, 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.

Applies To: