topic Re: SDE 10 upgrade 'ARITHABORT' in Data Management Questions https://community.esri.com/t5/data-management-questions/sde-10-upgrade-arithabort/m-p/4496#M319 <HTML><HEAD></HEAD><BODY><SPAN>I encountered the same problem and could not figure it out... if you have the solution please</SPAN></BODY></HTML> Fri, 04 Nov 2011 07:23:57 GMT YosephMekasha 2011-11-04T07:23:57Z SDE 10 upgrade 'ARITHABORT' https://community.esri.com/t5/data-management-questions/sde-10-upgrade-arithabort/m-p/4494#M317 <HTML><HEAD></HEAD><BODY><SPAN>Error(Check Datasets): Underlying DBMS error [Microsoft SQL Server Native Client 10.0: CREATE XML INDEX 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.]</SPAN><BR /><BR /><SPAN>FYI</SPAN><BR /><BR /><SPAN>Caused by database compatabilty level.</SPAN></BODY></HTML> Fri, 29 Jul 2011 11:28:55 GMT https://community.esri.com/t5/data-management-questions/sde-10-upgrade-arithabort/m-p/4494#M317 anthonychapa 2011-07-29T11:28:55Z Re: SDE 10 upgrade 'ARITHABORT' https://community.esri.com/t5/data-management-questions/sde-10-upgrade-arithabort/m-p/4495#M318 <HTML><HEAD></HEAD><BODY><SPAN>How did you fix this? I'm getting the same problem after upgrading SDE and trying to upgrade the geodatabase to the 10. What can I do about this?</SPAN></BODY></HTML> Fri, 29 Jul 2011 20:52:37 GMT https://community.esri.com/t5/data-management-questions/sde-10-upgrade-arithabort/m-p/4495#M318 CattyannCampbell 2011-07-29T20:52:37Z Re: SDE 10 upgrade 'ARITHABORT' https://community.esri.com/t5/data-management-questions/sde-10-upgrade-arithabort/m-p/4496#M319 <HTML><HEAD></HEAD><BODY><SPAN>I encountered the same problem and could not figure it out... if you have the solution please</SPAN></BODY></HTML> Fri, 04 Nov 2011 07:23:57 GMT https://community.esri.com/t5/data-management-questions/sde-10-upgrade-arithabort/m-p/4496#M319 YosephMekasha 2011-11-04T07:23:57Z Re: SDE 10 upgrade 'ARITHABORT' https://community.esri.com/t5/data-management-questions/sde-10-upgrade-arithabort/m-p/4497#M320 <HTML><HEAD></HEAD><BODY><SPAN>I found the solution it is just setting the comparability level of the current data. In my case I was migrating from SQL server 2000 to 2005. Thus used the following to fix the compatibility problem</SPAN><BR /><BR /><BR /><SPAN>exec sp_dbcmptlevel sde,90</SPAN></BODY></HTML> Fri, 04 Nov 2011 08:00:54 GMT https://community.esri.com/t5/data-management-questions/sde-10-upgrade-arithabort/m-p/4497#M320 YosephMekasha 2011-11-04T08:00:54Z