title: INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'.
body: <p>I have an .net application and SQL Server 2005 in the back-end. I have created the xml string for the bulk insert and passing that xml string to the SP. That xml string is being converted to the table type Table in the SP with IDENTITY column. As soon as I run the code I get the following error</p>
  
  <blockquote>
    <p>INSERT 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.</p>
  </blockquote>
  
  <p>But if I run the direct SP with the same parameters then it is working fine. Any idea?</p>