Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_add_targetsvrgrp_member (Transact-SQL)

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

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

[ @group_name = ] 'group_name'

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

[ @server_name = ] 'server_name'

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

0 (success) or 1 (failure)

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

Only members of the sysadmin fixed server role can execute this procedure.

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

USE msdb ;

EXEC dbo.sp_add_targetsvrgrp_member
   @group_name = N'Servers Maintaining Customer Information',
   @server_name = N'LONDON1' ;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft