Post reply

Stored Procedure Hangs but Works Fine after Recompile

  • October 1, 2008 at 8:10 am

    #193768

    Hi

    Folks

    I have a Stored Procedure which generally works great but some days it Just Hangs when we use it thorough our VB 6 application. At that time if I try to execute the SP in SSMS with the same parameter which the application is using it works fine. It only Hangs through the Application. To have a work around I recreated the Store Procedure and then the applications work fine. As of now I have added the "with recompile" option to the Stored Procedure. But if any one has any Ideas why this could happen I would applicate it.

    We are using SQL Server 2005 and VB 6 ADO.

    Thanks

    Raj Gujar

  • October 1, 2008 at 8:20 am

    #879497

    Hi,

    If possible, check with profiler when you get your system hanged out next time. It might give you a clue.

    Thanks

  • October 1, 2008 at 8:57 am

    #879532

    I will do it when next time it hangs, But My Concern is that It works great through SSMS at the very same time but hangs through the application. My Understanding is that if it has to impact performance it should be consistent through SSMS or Application

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

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