ListMemberServers 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 ListMemberServers method returns a NameList object that enumerates the member target servers of the multiserver administration, target server group referenced.

Syntax

object.ListMemberServers()asNameList

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.

Remarks

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.