Export (0) Print
Expand All
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.


sp_help_targetservergroup
    [ [ @name = ] 'name' ]

0 (success) or 1 (failure)

Column name Data type Description

servergroup_id

int

Identification number of the server group

name

sysname

Name of the server group

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

[ @name = ] 'name'

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

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

Community Additions

ADD
Show:
© 2014 Microsoft