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

PATCH for Article 817326

I am desperately looking for the patch across the internet
cause i really need this fix basically for WINDOWS
platform listed as follows:
Msbase.jar v 2.2.0030
Mssqlserver.jar v 2.2.0030
Msutil.jar v 2.2.0030
Please advise where can i extract all these patches.
DondonYou need to contact Microsoft product support. As the article states, the
fix is only available directly through them. You won't readily find them on
the Internet because of this.
"Dondon" <dondon@.newspage.com.sg> wrote in message
news:016701c38707$3bd80700$a001280a@.phx.gbl...
> I am desperately looking for the patch across the internet
> cause i really need this fix basically for WINDOWS
> platform listed as follows:
> Msbase.jar v 2.2.0030
> Mssqlserver.jar v 2.2.0030
> Msutil.jar v 2.2.0030
> Please advise where can i extract all these patches.
> Dondon