Jaa


TargetServerGroup.AddMemberServer Method

Assigns target server group membership to the specified target server.

Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Sub AddMemberServer ( _
    srvname As String _
)
public void AddMemberServer (
    string srvname
)
public:
void AddMemberServer (
    String^ srvname
)
public void AddMemberServer (
    String srvname
)
public function AddMemberServer (
    srvname : String
)

Parameters

  • srvname
    A String value that specifies the target server to be removed from the target server group.

Remarks

Use the AddMemberServer and RemoveMemberServer methods to configure multiserver administration target server groups. A target server can be a member of no group or a member of multiple groups.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Use an SMO Method with a Parameter in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

TargetServerGroup Class
TargetServerGroup Members
Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Scheduling Automatic Administrative Tasks in SQL Server Agent
Automating Administrative Tasks (SQL Server Agent)
sp_add_targetsvrgrp_member (Transact-SQL)