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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-10 : 07:51:39
|
| karthik writes "I am writing a web application using CFML with sql server 2000 as the backend(iam work on windows 98 os), when i try inserting a record in one of the tables i get the following error displayed"[Macromedia][SQLServer JDBC Driver][SQLServer]INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'. "I could not find out why. can you help me out of this maze?" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-02-10 : 08:58:35
|
| Most likely, you have a materialized view that uses one of the tables you are trying to insert into. Because of this, you need to SET ARITHABORT ON (just like the error says).Jay White{0} |
 |
|
|
HendersonToo
Starting Member
20 Posts |
Posted - 2004-02-11 : 17:08:43
|
| This also might be due to a computed column which is indexed. Take a look at books online's treatment of CREATE TABLE and the discussion on computed columns.Still, a SET ARITHABORT ON should get you the results you want. |
|
|
|
|
|
|
ARITHABORT