TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_delete_targetsvrgrp_member (Transact-SQL)

 

Removes a target server from a target server group.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

  
sp_delete_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 to remove from the specified group. server_name is nvarchar(30), with no default.

0 (success) or 1 (failure)

None

To run this stored procedure, users must be granted the sysadmin fixed server role.

The following example removes the server LONDON1 from the Servers Maintaining Customer Information group.

USE msdb ;  
GO  
  
EXEC sp_delete_targetsvrgrp_member   
    @group_name = N'Servers Maintaining Customer Information',  
    @server_name = N'LONDON1';  
GO  

sp_add_targetsvrgrp_member (Transact-SQL)
System Stored Procedures (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft