November 20, 2007 at 4:56 am
Dear all,
A particular SP is running through Query Analyzer but not thru Sql Agent.
Tried setting the SET Arithabort ON at db level.
Need ur help.
regards,
Ninad
November 20, 2007 at 5:04 am
What errors you are getting while executing?
Is it overflow or divide by zero errors? If this is the case, then you need to check the settings of the ANSI_WARNINGS operation.
EDIT:
Query analyzer has its own list of SET operations which can be customized, whereas SQL Agent depends on the server default settings or overriden settings in the executing batch.
Setting ARITHABORT to OFF and ANSI_WARNINGS to ON will still abort the statement. If you want the execution to continue, you need to set these operations to OFF mode.
--Ramesh
November 20, 2007 at 5:15 am
The application was returning the error “INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'
November 20, 2007 at 6:15 am
Are you using Indexed Views or Indexed computed columns in your procedure? If yes, try setting the ARITHABORT option set to ON at procedure level.
--Ramesh
November 20, 2007 at 1:34 pm
I would do the SET option at CONNECTION level 🙂
* Noel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply