How to enforce SQL Server policies in order to avoid users enabling bad practices
I assume you are referring to Policies in SQL Server here. Some types/level of policies, you cannot prevent. Technically, to &quot;prevent&quot; something using a policy in SQL Server means that the operation is performed, but the policy engine then does a rollback. Not all operations are rollback-able, hence the prevent functionality doesn't exist for all policy types.
So, in the end, you need to work out who has sysadmin privileges and make sure that only trusted persons has. In the end, this might have to go higher in the organization to get support.