Hi, I have a strange problem happening in our production. Certain stored procedure calls through the application are occassionally taking abnormally longer time. When I trace these calls and run the same SPs with same exact parameters through QA, these are executing much faster. I've compared the execution plans and understood that it is the culprit. For some reason, the SP calls through the application are using completely different (and apparently wrong) execution plans. If I recompile the SP using sp_recompile, then everything goes back to normal till I run into this problem again. Can anyone tell me what could be the reason for this behaviour ? The SP calls from application are embedded in to VC++ code and are passed to the backend through COM+ middle-tier. Please let me know if you need more details.