sp-syspolicy-set-config-enabled-transact-sql.md

title	sp_syspolicy_set_config_enabled (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sp_syspolicy_set_config_enabled sp_syspolicy_set_config_enabled_TSQL
dev_langs	TSQL
helpviewer_keywords	sp_syspolicy_set_config_enabled
ms.assetid	ddace1cc-ff23-4b61-8efb-8ded3df438bb
author	VanMSFT
ms.author	vanto

sp_syspolicy_set_config_enabled (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Enables or disables Policy-Based Management.

Transact-SQL Syntax Conventions

Syntax

  
sp_syspolicy_set_config_enabled [ @value = ] value  

Arguments

[ @value = ] value Determines whether Policy-Based Management is enabled. value is sqlvariant, and can be one of the following values:

• 0 (or 'false') = Disabled

• 1 (or 'true') = Enabled

Return Code Values

0 (success) or 1 (failure)

Remarks

You must run sp_syspolicy_set_config_enabled in the context of the msdb system database.

Permissions

Requires membership in the PolicyAdministratorRole fixed database role.

Important

Possible elevation of credentials: Users in the PolicyAdministratorRole role can create server triggers and schedule policy executions that can affect the operation of the instance of the [!INCLUDEssDE]. For example, users in the PolicyAdministratorRole role can create a policy that can prevent most objects from being created in the [!INCLUDEssDE]. Because of this possible elevation of credentials, the PolicyAdministratorRole role should be granted only to users who are trusted with controlling the configuration of the [!INCLUDEssDE].

Examples

The following example enables Policy-Based Management.

EXEC msdb.dbo.sp_syspolicy_set_config_enabled @value = 1;  
  
GO   

See Also

Policy-Based Management Stored Procedures (Transact-SQL)
sp_syspolicy_configure (Transact-SQL)