Skip to content

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

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
title sp_add_targetsvrgrp_member (Transact-SQL)
description Adds the specified target server to the specified target server group.
author markingmyname
ms.author maghan
ms.reviewer randolphwest
ms.date 06/23/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
f1_keywords
sp_add_targetsvrgrp_member
sp_add_targetsvrgrp_member_TSQL
helpviewer_keywords
sp_add_targetsvrgrp_member
dev_langs
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

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

Related content