Setting arithabort on in SSRS

  • Anyone know if this is possible? Have been consistently using a plan which does not have arithabort even though I set the option in the proc.

    When run manually in ssms, a plan gets create with arithabort.

    Even after I set arithabort on in start of stored proc, when I run it on ssrs, it is reusing the plan without the arithabort.

    Have already rewrote the proc with dynamic sql.

    Also, I have passed parameters to local variables.

    Regards

    MadTester/Madadmin

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

  • For anyone googling, the solution is that SSRS does not explicitly set the arithabort option.

    It will inherit whatever is set at the DB level.

    In my case, the DB's have been upgraded from 2000 to 2008 so the arithabort option is off as it was defaulted to OFF.

    You should not have the issue with DB's created with 2008 since it defaults to on, but if DB was created using SQL2000, would have defaulted to OFF.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

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

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