Paul I think I got it

I put "set arithabort on" in the Indexed View and now it
works. Do you know if this will cause any problems? Thanks
for all the help.
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
set arithabort on
go
ALTER view vu_ReplTransDTL
with schemabinding
as
select
TransDtlKey ,
CustomerKey ,
SerialNbr ,
TranCode ,
TransDate ,
TransDateShort = Convert(varchar(10), TransDate,
101),
TransDateMonth = Month(TransDate) ,
TransDateYear = Year(TransDate),
TransAmt ,
RefNbr ,
MerchName ,
City ,
State ,
RejectReason ,
PostDate ,
PostDateShort = Convert(varchar(10), PostDate,
101),
PostDateMonth = Month(PostDate),
PostDateYear = Year(PostDate),
CreateDate ,
MerchSIC
from dbo.TransDTL
go
set arithabort off
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

>--Original Message--
>Chris,
>I would like to look at this in more detail. Please can
you script out the
>table, indexed view and insert statement and I'll
reproduce it here.
>TIA,
>Paul Ibison
>
>.
>
Chris,
well spotted - Technet: "if SET ARITHABORT is OFF, CREATE, UPDATE, INSERT,
and DELETE statements on tables with indexes on computed columns or indexed
views will fail".
As far as I know as it is mandatory it is therefore fully catered for.
Cheers,
Paul Ibison