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)

Help and Information

Getting SQL Server 2005 Assistance