Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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)