Hi,
I am trying to schedule a stored procedure using SQL server Agent and i get the following error:
DELETE failed because the following SET options have incorrect settings: 'ARITHABORT'. [SQLSTATE 42000]
please help
regards,
hirenI found this in SQL Books Online.
Is it appropriate, ie do you have computed columns etc ?
If SET ARITHABORT is OFF, CREATE, UPDATE, INSERT, and DELETE statements on tables with indexes on computed columns or indexed views will fail.|||Well what's it set to?
Do you have a trigger on the table?|||Hi,
No there are no triggers. I have found the solution.
The connection related setting for the SQL server needs to be checked for the same. I performed the following steps...
1. In enterprise manager, right clicked on SQL Server i was accessing.
2. Selected properties->Connections.
3. Under 'default connection option', selected 'Arithmetic abort'
4. Clicked OK and restarted the server.
Thanks and regards,
henry
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment