All Questions
Tagged with policy-based-management sql-server-2017
3 questions
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
5
votes
1
answer
253
views
Prevent users creating constraints or indexes with no name
I have done some searching but haven't found a solution to my problem.
I started with some databases where users didn't care to name PK constraints, foreign keys or indexes, ending up with system ...
- 705