Arithabort error when trying to query a view

• geeb

  Old Hand

  Points: 358

  More actions

  June 16, 2009 at 3:05 am

  #211068

  Hi

  Newbie here i'm afraid -

  I have a view in SQL 2000 that works (ie displays without error in Ent Manager). However when I try and query the view in excel - I get the following message "select failed because the following SET options have incorrect settings ARITHABORT Statements(s) could not be prepared"

  Any ideas/suggestions - this view used to work prior to a software/database update issues by the software providers whoose database I am querying.

  The view itself is not using arithabort

  Thanks in advance for any

  Guy

• arun.sas

  SSChampion

  Points: 11831

  More actions

  June 16, 2009 at 4:00 am

  #1010084

  Hi,

  Duplicate post

  Answer here:

  http://www.sqlservercentral.com/Forums/Topic735508-8-1.aspx