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.
Syntax
sp_help_targetservergroup
[ [ @name = ] 'name' ]
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.
Argument
- [ @name= ] 'name'
Is the name of the target server group for which to return information. name is sysname, with a default of NULL.
Examples
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
See Also
Reference
sp_add_targetservergroup (Transact-SQL)
sp_delete_targetservergroup (Transact-SQL)
sp_update_targetservergroup (Transact-SQL)
System Stored Procedures (Transact-SQL)