Re: failed because the SET options have incorrect setting 'ARITHAB

Is this the UPDATE command that you are using and is giving you the error
message?

--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."

*Yet Another Certification Exam


"Jassim Rahma" <JassimRahma@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7988DBD7-C601-40AB-8EB4-4B1E79FB5757@xxxxxxxxxxxxxxxx
UPDATE [TEL_TEST].[dbo].[RATES]
SET [RATE_PLAN_ID] = <RATE_PLAN_ID, tinyint,>
,[ORIGIN] = <ORIGIN, varchar(25),>
,[COUNTRY_CODE] = <COUNTRY_CODE, varchar(8),>
,[NPA] = <NPA, varchar(8),>
,[NXX] = <NXX, varchar(8),>
,[LOCAL_NUMBER] = <LOCAL_NUMBER, varchar(20),>
,[PRIORITY] = <PRIORITY, tinyint,>
,[DESCRIPTION] = <DESCRIPTION, varchar(40),>
,[DIALING_PREFIX] = <DIALING_PREFIX, varchar(10),>
,[ROUTE_GROUP_ID] = <ROUTE_GROUP_ID, tinyint,>
,[PER_CALL_CHARGE] = <PER_CALL_CHARGE, decimal(15,4),>
,[PER_MINUTE_CHARGE] = <PER_MINUTE_CHARGE, decimal(15,4),>
,[BILLING_INCREMENT] = <BILLING_INCREMENT, smallint,>
,[GRACE_PERIOD] = <GRACE_PERIOD, smallint,>
,[MIN_SECS_BILLED] = <MIN_SECS_BILLED, smallint,>
,[SHORTEST_CALL_ALLOWED] = <SHORTEST_CALL_ALLOWED, smallint,>
,[BILLING_DELAY] = <BILLING_DELAY, smallint,>
,[PACKAGED_MINUTE_RATE] = <PACKAGED_MINUTE_RATE, decimal(15,4),>
,[USER_1] = <USER_1, varchar(50),>
,[USER_2] = <USER_2, varchar(50),>
,[USER_3] = <USER_3, varchar(50),>
,[USER_4] = <USER_4, varchar(50),>
,[USER_5] = <USER_5, varchar(50),>
,[USER_6] = <USER_6, varchar(50),>
,[USER_7] = <USER_7, varchar(50),>
,[USER_8] = <USER_8, varchar(50),>
,[USER_9] = <USER_9, varchar(50),>
,[USER_10] = <USER_10, varchar(50),>
,[RATE_TYPE] = <RATE_TYPE, tinyint,>
,[RATE_TIER_ID] = <RATE_TIER_ID, int,>
,[RATE_INTERVAL] = <RATE_INTERVAL, tinyint,>
,[SPEAK_RATE_INTERVAL] = <SPEAK_RATE_INTERVAL, bit,>
,[DISCONNECT_CHARGE] = <DISCONNECT_CHARGE, decimal(15,4),>
,[DISCONNECT_CHARGE_TYPE] = <DISCONNECT_CHARGE_TYPE, tinyint,>
,[SPEAK_DISCONNECT_CHARGE] = <SPEAK_DISCONNECT_CHARGE, bit,>
WHERE <Search Conditions,,>



"Arnie Rowland" wrote:

Please send the table DDL and a few rows of sample data in the form of
INSERT statements. It will be easier to assisty you if we have the
'entire'
picture.

Thanks,

--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."

*Yet Another Certification Exam


"Jassim Rahma" <JassimRahma@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7EAB2397-CD9D-4B9F-9B41-F151AC482E49@xxxxxxxxxxxxxxxx
Why i am getting this error:

update failed because the following SET options have incorrect setting:
'ARITHABORT'

when i try the following simple SQL in the SQL Management Express 2005:

update rates set rates.ORIGIN = '800880011_ali' where
rates.rate_plan_id =
3





.

Relevant Pages