Options
DLM dashboard stop Maintenance plans from running
rmg1
Posts: 11 Bronze 1
Hi all
We installed the DLM dashboard on one of our test servers which also had a maintenance plan in effect.
Part of the maintenance plan is to update statistics.
It looks like the trigger (RG_SQLLighthouse_DDLTrigger) blocks the updating of statistics with the following error message:-
"An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back."
Is this by design or is it a small bug in the code?
Regards
Richard
We installed the DLM dashboard on one of our test servers which also had a maintenance plan in effect.
Part of the maintenance plan is to update statistics.
It looks like the trigger (RG_SQLLighthouse_DDLTrigger) blocks the updating of statistics with the following error message:-
"An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back."
Is this by design or is it a small bug in the code?
Regards
Richard
Comments