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 |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2005-10-18 : 04:58:20
|
| Hi All Gurus,I am getting an error while inserting in table INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'.There has been no change made in the database. It was working till yesterday.Please help. Thanks in advanceRegardsSachin Samuel |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2005-10-18 : 06:41:09
|
| I tried this too but of no use :(.Don't know what went wrong.Please help.RegardsSachin |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-18 : 07:27:49
|
| New version of ADO on the client end?Attempting to insert through a VIEW (but you said DB had not changed)Inserting into a table that has a COMPUTED column (but you said DB had not changed)SProc or VIEW recreated (without appropriate SET settings) (might have been done by some "rebuild" routine, which would nullify "DB has not changed")Kristen |
|
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2005-10-18 : 07:37:38
|
| Hi Kristen,There is no change in version of ADO.I fixed the problem by specifying SET ARITHABORT ON. But I am still not sure why this error came, when everything was working till yesterday. Can any defragmentation of indexes using DBCC INDEXDEFRAG can cause this? Or Shrinking of DB which is stoped abruptly? Thanks in advanceRegardsSachin |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-18 : 08:08:27
|
| Don't think so. But a RECOMPILE of SProcs / Views might.Kristen |
|
|
|
|
|
|
ARITHABORT