SQLServer The definition of object 'name' has changed since it was compiled

Question

I'm getting an error after updating a procedure and executing it.

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

Is there a fix for this error ?

Answer 1

Are you changing the procedure in one window and executing it in another?

Yes, this is the case. I'm updating it in SSMS and executing a separate application which calls the procedure

You need to end the session in which you are editing the procedure. The changes are only visible in the editing session until they are committed.