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
Showing posts with label arithabort. Show all posts
Showing posts with label arithabort. Show all posts
Subscribe to:
Posts (Atom)