ListMemberServers Method

SQL-DMO

SQL-DMO

ListMemberServers Method

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

Applies To
TargetServerGroup Object
Syntax

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 TSX servers by enlisted name.

Remarks

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

TSX 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.