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.
Catch-all queries done right Gail Shaw's Performance Blog