.png)
sp_help_targetservergroup (Transact-SQL)
SQL Server 2005
Lists all target servers in the specified group. If no group is specified, SQL Server returns information about all target server groups.
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
