| title | sp_syspolicy_unsubscribe_from_policy_category (Transact-SQL) | ||
|---|---|---|---|
| description | Deletes a policy category subscription for the current database. | ||
| 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]
Deletes a policy category subscription for the current database.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_syspolicy_unsubscribe_from_policy_category
[ @policy_category = ] N'policy_category'
[ ; ]
The name of the policy category subscription that you want to delete. policy_category is sysname, and is required.
To obtain values for @policy_category, query the msdb.dbo.syspolicy_policy_categories system view.
0 (success) or 1 (failure).
You must run sp_syspolicy_unsubscribe_from_policy_category in the context of the database where you want to remove a policy category subscription.
Requires membership in the db_owner fixed database role.
The following example deletes a subscription to the Finance policy category for the specified database.
USE <database_name>;
GO
EXECUTE sys.sp_syspolicy_unsubscribe_from_policy_category
@policy_category = N'Finance';
GO