April 4, 2008 at 12:09 am
When i try to update an integer column , i am getting the above error
UPDATE failed because the following SET options have incorrect
settings: 'ARITHABORT'
Update Engage
Set EngageID = 2
May i know the reason why i am getting this error.
April 4, 2008 at 12:34 am
is it computed column? Thats the reason behind failure.
set arithabort on before executing update statement
[font="Verdana"]--www.sqlvillage.com[/size][/font]
April 4, 2008 at 12:38 am
It's not a computed Column.i am just updating the value 2 to the column.
Thats it.
April 4, 2008 at 7:34 pm
Do you have an indexed view referencing the table?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply