We also encountered this problem when we generate using sql compare application. Our workaround is to drop and recreate the procedure or functions. Great article!