Post reply

Wierd Stored Procedure problem

  • November 18, 2003 at 4:40 pm

    #160971

    We use VB/DCOM as a front end for Sql Server 7.0 SP4. There is a particular stored procedure that always runs very fast directly on the server but from time to time causes a timeout error via our VB application. If I copy then delete the stored procedure and then re-write with the same code, the procedure again runs fine through our VB interface. Seems that the sp is somehow getting corrupted. Has anyone seen this problem before or have any advice. This one is driving me crazy!! Thanks

  • November 19, 2003 at 12:32 am

    #482549

    try updating the index statistics on the tables used in the procedure - check the query plan using SET SHOWPLAN options .. if all else fails try running the procedure using WITH RECOMPILE

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply