Post reply

sp_procedure_params_rowset

  • July 5, 2004 at 5:50 am

    #84843

    I have a developer who has built a crystal report to pull data back from sql2000 server.For some data the report works fine. Others it hangs.

    I ran profiler and captured this when it fails:

    exec [RUHDischargeSummary]..sp_procedure_params_rowset N'PrintSummary', 1, NULL, NULL

    This statement completes but app then stops.

    I have found that sp_procedure_params_rowset returns information about parameters for my stored procedure PrintSummary.

    When succesful the profiler captures the next command which is the printsummary proc follwed by the parameters. I can run the stored proc with the parameters that cause failure and all completes OK.

    Can you help?

    Thanks

     

  • July 5, 2004 at 7:19 am

    #513291

    This is a shot in the dark, but have you checked for locks?  When the report is hanging, execute sp_who2 in query analyser.  See if your process is blocked by another by looking in the 'Blocked' column.

    If yes, try using the NOLOCK hint for all SELECT statements.

     

    When in doubt - test, test, test!

    Wayne

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

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