Job to monitor changes to functions, triggers or procudures

eric85635 · February 27, 2019, 4:55pm

Hello
How to configure a job to monitor changes to functions, triggers or procedures. Thanks

ScottPletcher · February 27, 2019, 5:33pm

You'd need to create a DDL trigger in every db to capture the changes, say into a table. Then you could have a job that reported on those tables on any schedule you wanted.