SQLServer Object "name" definition has changed since it was compiled

Question

I get an error after updating the procedure and executing it.

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

Is there a fix for this error?

+3

TheLegendaryCopyCoder 07 oct. 14 at 12:52

1 answer

Dave · Accepted Answer · 2014-10-07T17:50:34+0000

Are you changing a procedure in one window and running it in another?

Yes it is. I am updating it in SSMS and running a separate application that calls the procedure

You need to end the session in which you are editing the procedure. Changes are visible only in the editing session until they are completed.