Definition changed error in SP execution after DLM Install
borussiamg
Posts: 2
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
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
Comments
Redgate Software