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

sp_help_targetservergroup (Transact-SQL)

 

Lists all target servers in the specified group. If no group is specified, SQL Server returns information about all target server groups.

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

Topic link icon Transact-SQL Syntax Conventions

  
sp_help_targetservergroup  
    [ [ @name = ] 'name' ]  

[ @name= ] 'name'
Is the name of the target server group for which to return information. name is sysname, with a default of NULL.

0 (success) or 1 (failure)

Column nameData typeDescription
servergroup_idintIdentification number of the server group
namesysnameName of the server group

Permissions to execute this procedure default to the sysadmin fixed server role.

A. Listing information for all target server groups

This example lists information for all target server groups.

USE msdb ;  
GO  
  
EXEC dbo.sp_help_targetservergroup ;  
GO  

B. Listing information for a specific target server group

This example lists information for the Servers Maintaining Customer Information target server group.

USE msdb ;  
GO  
  
EXEC dbo.sp_help_targetservergroup   
    N'Servers Maintaining Customer Information' ;  
GO  

sp_add_targetservergroup (Transact-SQL)
sp_delete_targetservergroup (Transact-SQL)
sp_update_targetservergroup (Transact-SQL)
System Stored Procedures (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft