SQL Server Error,incorrect settings: 'ARITHABORT'

See more:

SQL

SQL-Server-2008R2

i am getting this error when i am select data throw xml in sql server database 2008

SELECT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations



My query is,

WITH PriceEmailItems as(
    SELECT Split.a.value('.', 'VARCHAR(100)') AS PriceItems FROM
    (SELECT CAST ('<price>' + REPLACE(Left([Items], Len([Items])-1), ',', '</price><price>') + '</price>' AS XML) AS Subcat
     FROM rpriceemail where planenddate>getdate()) AS A CROSS APPLY Subcat.nodes ('/price') AS Split(a))

SELECT DISTINCT(PriceItems), Rmetalcats.Category, RMetalcats.subcat, RMetalcats.Packages, COUNT(PriceItems) as howmany, Country FROM PriceEmailItems
    INNER JOIN RMetalCats on RMetalCats.ID=PriceItems group by PriceItems, Rmetalcats.Category, RMetalcats.subcat,Packages, Country

How can i solve it......