• I'm new to this forum and writing queries as well.

    I have tried running this script in Management Studio and it runs fine, however if I try to build a report in VS2k8 I get the following error: An error occurred while the query design method was being saved. SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'.

    This comes up after pasting the query into the design query window and hitting next.

    Does anyone have a an easy solution for this?

    Thanks..