sp_help_targetservergroup

Transact-SQL Reference

Transact-SQL Reference

sp_help_targetservergroup

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

Syntax

sp_help_targetservergroup [ [ @name = ] 'name' ]

Argument

[@name =] 'name'

Is the name of the target server group for which to return information. name is varchar(100), with a default of NULL.

Return Code Values

0 (success) or 1 (failure)

Result Sets
Column name Data type Description
servergroup_id int Identification number of the server group
name sysname Name of the server group
Permissions

Permissions to execute this procedure default to the sysadmin fixed server role and the db_owner fixed database role, who can grant permissions to other users.

Examples

This example lists all target server groups first, followed by all other target servers in the Servers Maintaining Customer Information target server group.

USE msdb
EXEC sp_help_targetservergroup 
EXEC sp_help_targetservergroup 'Servers Maintaining Customer Information'

See Also

sp_add_targetservergroup

sp_delete_targetservergroup

sp_update_targetservergroup

System Stored Procedures