ListMemberServers Method (SQL-DMO)

The ListMemberServers method returns a NameList object enumerating the member TSX servers of the multiserver administration, TSX server group referenced.

Applies To

TargetServerGroup Object

Syntax

object.ListMemberServers( ) as NameList

Part Description
object Expression that evaluates to an object in the Applies To list

Returns

A NameList object enumerating TSX servers by enlisted name.

Remarks

When a SQL Server Agent acts as a master (MSX) server for multiserver administration servers, known execution targets (TSX servers) can be grouped for easier targeting of multiple servers at one time.

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 containing the TargetServerGroup object references a multiserver administration master.

Prototype (C/C++)

HRESULT ListMemberServers(
LPSQLDMONAMELIST* ppServerNames);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.