• As you have mention that renaming the stored procedure works fine. Based on this info you can try executing stored procedure with recompile option every time and see if you gain any performance? However recompile every time will have slight load on the server and I assume that this procedure is not executing very frequently.

    Though this might not have the ideal solution and you need to study execution plan as mention by other mate in earlier post.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."