• If you have done all the things Gsquare mentioned, then my guess is that you will not have any problems deploying the new store procedure. It will help if you will say what the sp does.