| title | sp_syspolicy_rename_policy_category (Transact-SQL) | ||
|---|---|---|---|
| description | Renames an existing policy category in Policy-Based Management. | ||
| author | VanMSFT | ||
| ms.author | vanto | ||
| ms.reviewer | randolphwest | ||
| ms.date | 06/23/2025 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server]
Renames an existing policy category in Policy-Based Management.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_syspolicy_rename_policy_category
{ [ @name = ] N'name' | [ @policy_category_id = ] policy_category_id }
, [ @new_name = ] N'new_name'
[ ; ]
The name of the policy category that you want to rename. @name is sysname, and must be specified if @policy_category_id is NULL.
The identifier for the policy category that you want to rename. @policy_category_id is int, and must be specified if @name is NULL.
The new name for the policy category. @new_name is sysname, and is required. Can't be NULL or an empty string.
0 (success) or 1 (failure).
You must run sp_syspolicy_rename_policy_category in the context of the msdb system database.
You must specify a value for either @name or @policy_category_id. Both can't be NULL. To obtain these values, query the msdb.dbo.syspolicy_policy_categories system view.
Requires membership in the PolicyAdministratorRole fixed database role.
[!INCLUDE policy-administrator-role]
The following example renames a policy category that is named Test Category 1 to Test Category 2.
EXECUTE msdb.dbo.sp_syspolicy_rename_policy_category
@name = N'Test Category 1',
@new_name = N'Test Category 2';
GO