Skip to content

Latest commit

 

History

History
79 lines (55 loc) · 1.99 KB

sp-add-targetsvrgrp-member-transact-sql.md

File metadata and controls

79 lines (55 loc) · 1.99 KB
Raw
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sp_add_targetsvrgrp_member (Transact-SQL)
Adds the specified target server to the specified target server group.
markingmyname
maghan
randolphwest
06/02/2023
sql
system-objects
reference
sp_add_targetsvrgrp_member
sp_add_targetsvrgrp_member_TSQL
sp_add_targetsvrgrp_member
TSQL

sp_add_targetsvrgrp_member (Transact-SQL)

[!INCLUDE SQL Server]

Adds the specified target server to the specified target server group.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

sp_add_targetsvrgrp_member
    [ @group_name = ] 'group_name'
    , [ @server_name = ] N'server_name'
[ ; ]

Arguments

[ @group_name = ] 'group_name'

The name of the group. @group_name is sysname, with no default.

[ @server_name = ] N'server_name'

The name of the server that should be added to the specified group. @server_name is nvarchar(30), with no default.

Return code values

0 (success) or 1 (failure).

Result set

None.

Remarks

A target server can be a member of more than one target server group.

Permissions

[!INCLUDE msdb-execute-permissions]

Examples

The following example adds the group Servers Maintaining Customer Information and adds the LONDON1 server to that group.

USE msdb;
GO

EXEC dbo.sp_add_targetsvrgrp_member
    @group_name = N'Servers Maintaining Customer Information',
    @server_name = N'LONDON1';
GO

Related content