Поделиться через


ListMemberServers Method

В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.

The ListMemberServers method returns a NameList object that enumerates the member target servers of the multiserver administration, target server group referenced.

Синтаксис

object
.ListMemberServers(
)
as
NameList

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

Prototype (C/C++)

HRESULT ListMemberServers(
LPSQLDMONAMELIST* ppServerNames);

Returns

A NameList object that enumerates target servers by enlisted name.

Замечания

When a SQL Server Agent acts as a master server for multiserver administration servers, known execution target servers can be grouped for easier targeting of multiple servers.

Target server groups are defined only for a SQL Server Agent acting as a multiserver administration master. The ListMemberServers method only returns members when the JobServer object that contains the TargetServerGroup object references a multiserver administration master.