Lesson 1: Create and Apply an Off By Default Policy


Applies To: SQL Server 2016

Using Policy-Based Management policies, you can administer one or more instances of SQL Server, one or more instance objects, server instances, one or more databases, or one or more database objects. As the database administrator, you want to ensure that certain servers do not have Database Mail enabled. In this lesson, you will create a condition and a policy that sets that server option. You will test the server to see whether it complies with the policy. Then, you will use the policy to reconfigure the server to bring the server into compliance.

This lesson contains the following topics:

Create the Off By Default Policy

Lesson 2: Create and Apply a Naming Standards Policy

Community Additions