sys.sp_syspolicy_rename_policy

Description

Renames an existing policy in Policy-Based Management.

Syntax

sp_syspolicy_rename_policy
{ [ @name = ]
N
'name'
| [ @policy_id = ] policy_id }
, [ @new_name = ]
N
'new_name'
[ ; ]

Examples

Example 1

sp_syspolicy_rename_policy

Example 2

msdb

Example 3

NULL

Example 4

msdb.dbo.syspolicy_policies

Example 5

Test Policy 1

Example 6

Test Policy 2

Example 7

EXECUTE msdb.dbo.sp_syspolicy_rename_policy
@
name
= N
'Test Policy 1'
,
@new_name = N
'Test Policy 2'
;
GO