Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


SQL Server 2000

Lists all target servers in the specified group. If no group is specified, Microsoft® SQL Server™ returns information about all target server groups.


sp_help_targetservergroup [ [ @name = ] 'name' ]


[@name =] 'name'

Is the name of the target server group for which to return information. name is varchar(100), with a default of NULL.

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 to execute this procedure default to the sysadmin fixed server role and the db_owner fixed database role, who can grant permissions to other users.


This example lists all target server groups first, followed by all other target servers in the Servers Maintaining Customer Information target server group.

USE msdb
EXEC sp_help_targetservergroup 
EXEC sp_help_targetservergroup 'Servers Maintaining Customer Information'

See Also




System Stored Procedures

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft