Export (0) Print
Expand All
Expand Minimize

sp_update_targetservergroup (Transact-SQL)

Changes the name of the specified target server group.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

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)

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

sp_update_targetservergroup must be run from the msdb database.

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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft