July 8, 2007 at 11:36 am
I have sql server 2005 sp2, I am running maintenance wizard plann for (Re-building indexes, re-oraganize index, update statistic, check database integrity , log backup and database back up)
This is the error I get, how can I fix this?
Executing the query "UPDATE STATISTICS [dbo].[CaseNum]
WITH FULLSCAN
" failed with the following error: "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 query notifications and/or xml data type methods.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
July 11, 2007 at 9:22 am
Did you allowed statistics setting on your dB?Check settings on your dB related to statistics growth
HTH
July 11, 2007 at 11:19 am
This use to work fine on other server. only thing I did was resotred database on new server with sp2 and it's a 64bit version of sql.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply