Delete a Policy-Based Management Policy

This topic describes how to delete a Policy-Based Management policy in SQL Server 2012 by using SQL Server Management Studio or Transact-SQL.

In This Topic

• Before you begin:

  Security

• To delete a policy, using:

  SQL Server Management Studio

Before You Begin

Security

Permissions

Requires membership in the PolicyAdministratorRole role in the msdb database.

[Top]

Using SQL Server Management Studio

To delete a policy

1. In Object Explorer, click the plus sign to expand the server that contains the Policy-Based Management policy that you want to delete.

2. Click the plus sign to expand the Management folder.

3. Click the plus sign to expand Policy Management.

4. Click the plus sign to expand the Policies folder.

5. Right-click the policy that you want to delete and select Delete.

6. In the Delete Object dialog box, ensure that the correct condition is selected and then click OK.

[Top]