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 |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2007-05-29 : 10:12:39
|
| Because of a calculated column on one of my tables, I need to switch ARITHABORT ON.I don't really want to go this route:http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=82884I presume there's a way to set it on when calling ExecuteNonQuery? Just don't know how...I was thinking something like this:ExecuteNonQuery(MyConnection, CommandType.Text, "set arithabort on; exec mp_MyUpdateSproc", myParams)But the bit that passes in params wouldn't really work. Any other ideas? |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-29 : 10:21:19
|
We've converted our Computed Columns into "real" ones. Either by Trigger, or by using a VIEW to do the Computed Columns stuff. PITA  Kristen |
 |
|
|
|
|
|
ARITHABORT ON in VB.NET