Execute permission denied tempdb object RG_WhatsChanges_V4

savuthusavuthu Posts: 2
We keep getting the error The EXECUTE permission denied on the object "RG_WhatsChanged_v4", database tempdb, schema 'DBO' on commit changes tab. We use shared database model.

In the past we resolved this by dropping the tempdb procedure and one time we all upgraded to the same version and that seemed to have resolved it. This is the third time we are running into this issue, it seems to me that the tempdb procedure is orphaned by a redgate session. When we don't see this procedure hanging in tempdb, everything works fine.
Tagged:

Comments

Sign In or Register to comment.