Technokrat
Programmer
I need to create a script that will alert an operator when a trigger, stored proc, or scheduled process is missing?
We have run into problems where a replication is re-initialized and critical triggers end up being dropped/lost.
We want to create a script to monitor the process and notify somebody if a business critical item (trigger, stored proc, etc.) is lost/missing.
Anybody done anything like this?
We have run into problems where a replication is re-initialized and critical triggers end up being dropped/lost.
We want to create a script to monitor the process and notify somebody if a business critical item (trigger, stored proc, etc.) is lost/missing.
Anybody done anything like this?