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 |
|
djokerss
Starting Member
28 Posts |
 Posted - 2004-10-28 : 04:46:28
|
| when i want to insert data into table there was an errorServer: Msg 1934, Level 16, State 1, Line 1INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'.i've try to change set arithabort on and offbut it's error still occured.please help me....my transaction stoped because of that...thanks before |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-10-28 : 05:31:37
|
| r u executing the insert through QA?check this link [url]http://support.microsoft.com/kb/305333[/url]He is a fool for five minutes who asks , but who does not ask remains a fool for life!http://www.sqldude.4t.comhttp://www.sqljunkies.com/weblog/sqldude |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-28 : 09:52:38
|
| The thing that called the current thing, rather than just the current thing, often has to have SET ARITHABORT ON to solve this.For example I have used something like:CREATE PROCEDURE MyWrapperSPASSET ARITHABORT ONEXEC MyRealSPGOto get around the problem. Also when executing dynamic SQL from ASP:SET ARITHABORT ON; SELECT * FROM MyTablecan cure the problem (but often it needs a wrapper SProc too)Kristen |
|
|
|
|
|
|
settings: 'ARITHABORT'