sp_help_targetservergroup (Transact-SQL)
Applies to:
SQL Server
Lists all target servers in the specified group. If no group is specified, SQL Server returns information about all target server groups.
Transact-SQL syntax conventions
Syntax
sp_help_targetservergroup [ [ @name = ] N'name' ]
[ ; ]
Arguments
[ @name = ] N'name'
The name of the target server group for which to return information. @name is sysname, with a default of NULL
.
Return code values
0
(success) or 1
(failure).
Result set
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.
Examples
A. List 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. List 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
Related content
Povratne informacije
https://aka.ms/ContentUserFeedback.
Kmalu na voljo: V letu 2024 bomo ukinili storitev Težave v storitvi GitHub kot mehanizem za povratne informacije za vsebino in jo zamenjali z novim sistemom za povratne informacije. Za več informacij si oglejte:Pošlji in prikaži povratne informacije za