Filter constraints in DLM Dashboard?
bpinto
Posts: 1 New member
Is there a way to ignore WITH CHECK and WITH NOCHECK changes so these are not recognized as "drift"? For example, I would want the following statements to be ignored
ALTER TABLE dbo.myTable NOCHECK CONSTRAINT ALL
ALTER TABLE dbo.myTable CHECK CONSTRAINT ALL
ALTER TABLE dbo.myTable NOCHECK CONSTRAINT FK_myTable_X
ALTER TABLE dbo.myTable CHECK CONSTRAINT FK_myTable_X
ALTER TABLE dbo.myTable NOCHECK CONSTRAINT ALL
ALTER TABLE dbo.myTable CHECK CONSTRAINT ALL
ALTER TABLE dbo.myTable NOCHECK CONSTRAINT FK_myTable_X
ALTER TABLE dbo.myTable CHECK CONSTRAINT FK_myTable_X
