Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sp_update_targetservergroup (Transact-SQL)
Collapse the table of content
Expand the table of content

sp_update_targetservergroup (Transact-SQL)

Changes the name of the specified target server group.


sp_update_targetservergroup
     [@name =] 'current_name' ,
     [@new_name =] 'new_name'

[ @name =] 'current_name'

The name of the target server group. current_name is sysname, with no default.

[ @new_name =] 'new_name'

The new name for the target server group. new_name is sysname, with no default.

0 (success) or 1 (failure)

sp_update_targetservergroup must be run from the msdb database.

To run this stored procedure, users must be granted the sysadmin fixed server role.

The following example changes the name of the target server group Servers Processing Customer Orders to Local Servers Processing Customer Orders.

USE msdb ;
GO

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

Community Additions

ADD
Show:
© 2015 Microsoft