ARITHABORT
-
UPDATE RM SET Email = 'dinesh@dinesh.lk'Where RespNo = 437956
it gives me following error
[Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE failed because the following SET options have incorrect settings: 'ARITHABORT'.
I found that this table is link with a index view . When I remove the index and schma binding it works as expected.
What is the cause? what is the relation between ARITH ABOART and Index View
My Blog:
http://dineshasanka.spaces.live.com/ -
When set to ON, an overflow or divide-by-zero error causes the query or batch to terminate. If the error occurs in a transaction, the transaction is rolled back. When set to OFF, a warning message is displayed if one of these errors occurs, but the query, batch, or transaction continues to process as if no error occurred.
SET ARITHABORT must be set to ON when you create or manipulate indexes on computed columns or indexed views
The status of this option can be determined by examining the IsArithmeticAbortEnabled property of the DATABASEPROPERTYEX function.
-
This behaviour is by design try using
SET ARITHABORT ON
(keep the update in its own batch dont mix with other sql statments)
Andy. -
Thank Bell,
But my question is it is not a overflow or divide-by-zero so then why it is giving such a error!
My Blog:
http://dineshasanka.spaces.live.com/ -
See the bold part of my last post - you say in your original post that when you remove the index on the view the update works - the update wont work with the index on as the update will cause manipulation to the index and as my first post said
SET ARITHABORT must be set to ON when you create or manipulate indexes on computed columns or indexed views
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply