All Questions
Tagged with policy-based-management sql-server-2017
2 questions with no upvoted or accepted answers
1
vote
0
answers
70
views
Issue with table naming policy with PBM - can't create it passed in the condition or not
I used PBM to create a condition to blocking create tables if nomenclature no haven't the prefix tbl:
EXEC msdb.dbo.sp_syspolicy_update_condition @condition_id=24, @description=N'Necessário ...
- 324
1
vote
1
answer
130
views
Using Policy-Based Management to check backup history for an Availability Group database
I like using Policy-Based Management to do some simple "everything's okay" sanity checks and email me if something goes out of spec. Typically, I validate the time since the last full backup, both to ...
- 9,698