sys.sp_update_targetservergroup

Description

Changes the name of the specified target server group.

Syntax

sp_update_targetservergroup
[ @name = ]
N
'name'
, [ @new_name = ]
N
'new_name'
[ ; ]

Remarks

Changes the name of the specified target server group.

The name of the target server group.

, with no default.

The new name for the target server group.

, with no default.

(success) or

To run this stored procedure, users must be granted the

fixed server role.

Examples

Example 1

sp_update_targetservergroup

Example 2

msdb

Example 3

Servers Processing
Customer Orders

Example 4

Local Servers Processing Customer Orders

Example 5

USE msdb;
GO
EXECUTE dbo.sp_update_targetservergroup
@
name
= N
'Servers Processing Customer Orders'
,
@new_name = N
'Local Servers Processing Customer Orders'
;
GO