ArithAbort Problem

Hiya

I have recently set up a view with a clustered and a non-clustered index on it (t-SQL is below). To create the view and indexes I set arithabort to on as per the help file articles. However, this setting is causing the following error when my application calls a stored procedure setting values in a table:


The transaction was rolled back for the following reason:
UPDATE failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.
Last Query: MFSetApplicant

I am including 2 columns from the table the sp is trying to update in the view. The sp is a very basic update statement, setting all the values in the table row and using the primary key in the where clause. The sp ran fine with no errors prior to changing the setting of arithabort and adding the view and indexes and has been doing so for the last 5 years.

I have tried setting arithabort to off and the error keeps being thrown. I have tried tracing the transaction and can see nothing wrong with the way the sp is being used or the parameters being passed in. Is there any way to change this setting back to off so I can stop this error being thrown? Am I missing something obvious?

thanks



Code Block

SET NUMERIC_ROUNDABORT OFF;
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,
QUOTED_IDENTIFIER, ANSI_NULLS ON;
Go

CREATE VIEW [dbo].[View_LeadMatching] WITH SCHEMABINDING
AS
SELECT dbo.MFApplicants.ApplicantNo, dbo.MFApplicants.Surname, dbo.MFApplicantContactDetails.PostCode
FROM dbo.MFApplicants INNER JOIN dbo.MFApplicantContactDetails
ON dbo.MFApplicants.ApplicantNo = dbo.MFApplicantContactDetails.ApplicantNo
AND dbo.MFApplicants.MortgageRef = dbo.MFApplicantContactDetails.MortgageRef
GO
----------------------------------------------------------------------
CREATE UNIQUE CLUSTERED INDEX IX_View_LeadMatching_ApplicantNo
ON [View_LeadMatching] (ApplicantNo);
GO
----------------------------------------------------------------------
CREATE NONCLUSTERED INDEX IX_View_LeadMatching
ON [View_LeadMatching] (Surname, Postcode)
GO