What are the challenges you face when working across database platforms? Take the survey
Options

Definition changed error in SP execution after DLM Install

borussiamgborussiamg Posts: 2
edited August 22, 2016 7:35AM in DLM Automation
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

Comments

Sign In or Register to comment.