Post reply

Stored procedure works fine in SSMS, not in SSRS

  • June 19, 2015 at 6:03 am

    #319177

    I have a stored procedure that runs fine in management studio v2008 but, times out with an error in SSRS. Any thoughts?

  • June 19, 2015 at 6:08 am

    #1806633

    Try to find the execution plan of the query for both applications. Chances are they are different.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 19, 2015 at 6:20 am

    #1806637

    I apologize for not being clearer. It times out while adding the data set.

  • June 19, 2015 at 12:47 pm

    #1806798

    There is a timeout option in the dataset properties itself. When creating or editing it set it to 0 and you should be good. It's located on the same screen as where you enter your dataset string/proc in.

  • June 22, 2015 at 3:59 am

    #1806974

    It is already set to zero.

  • June 22, 2015 at 11:50 am

    #1807130

    Can you provide more detail then?

    By studio v2008, do you mean SQL Server Management Studio? How long does it take in SSMS? What kind of data is it returng? IE text blobs, or images, any kind of aggregations?

  • June 22, 2015 at 11:54 am

    #1807135

    SSMS v2008. The procedure takes about a minute and a half. It returns names and dates.

Viewing 7 posts - 1 through 6 (of 6 total)

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