How can we help you today? How can we help you today?

Definition changed error in SP execution after DLM Install

After runnign the DLM installation scripts taken from https://documentation.red-gate.com/display/DDB1/Creating+a+login+with+the+correct+permissions+in+Dashboard+1.6.8+and+earlier I ran into the following error:

The definition of object 'sp_MailMonitor' has changed since it was compiled.

It turned out that the error was caused by the following line in a stored procedure:

ALTER AUTHORIZATION ON [dbo].[smySP] TO SCHEMA OWNER;

Could anyone explain what is going wrong here?

(SQL2008 R2)

TY
borussiamg
0

Comments

1 comment

Sort by
  • Rob C
    I'm not sure that this is related to DLM Dashboard as that is not a DLM Dashboard object. You might want to try using sp_recompile on the sp_MailMonitor object to force a recompile before it is next run.
    Rob C
    0

Add comment

Please sign in to leave a comment.