Manual DMF Policy Enforcement in SQL Server

The Declarative Management Framework allows you to manually reconfigure policy targets so that they comply with some policies. It is important to note, however, that this manual reconfiguration cannot resolve all policy compliance issues. SQL Server will be able to modify database settings, reconfigure permissions and perform similar tasks but it cannot, for example, change the name of a stored procedure without administrator intervention.

Read the full story: Manual DMF Policy Enforcement in SQL Server