sp_add_targetsvrgrp_member (Transact-SQL)
Applies to:
SQL Server
Adds the specified target server to the specified target server group.
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
This stored procedure is owned by the db_owner role. You can grant EXECUTE
permissions for any user, but these permissions may be overridden during a SQL Server upgrade.
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