Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vack
Aged Yak Warrior
530 Posts |
 Posted - 2008-07-23 : 14:34:47
|
| Getting the following Error:Insert failed because the following SET options have incorrect settings: 'ARITHABORT'It looks lide the cause if from a couple of triggers. One trigger is inserting records into a table with calcuated fields. Any one know how to fix this??? |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2008-07-23 : 14:39:06
|
| BOL has a nice description:If SET ARITHABORT is OFF, CREATE, UPDATE, INSERT, and DELETE statements on tables with indexes on computed columns or indexed views will fail. For more information about required SET option settings with indexed views and indexes on computed columns, see "Considerations When You Use the SET Statements" in SET (Transact-SQL).I'm not 100% if that is your issue, but you might want to read up on SET ARITHABORT in BOL. |
 |
|
|
|
|
|
Insert Failed arithabort