Internal SQL Server error

microsoft.public.sqlserver.programming

18 Aug 2005 10:38 PM

Colin Dawson

Hi all.

I think that I may have found a bug in SQL Server SP4! The problem is that
I'm trying to insert data into a table which is referenced by an indexed
view. I haven't got the command to hand, but it's a nasty little beastie
that's using openrowset to connect to a different server using MSDTC.

I've read the KB Article http://support.microsoft.com/kb/830466 and have
already installed SP4 on both SQL 2000 servers which are involved in this
situation.

As a workaround to the problem I've dropped the index from the view, which
will be OK in the short term, but the database performance is degradated by
this. Adding the index after performing the insert works without issue, so
this is a possible workaround, but I don't want to do this later.

Have anyone else seen this issue or is it worth getting in contact with SQL
Support over this one? I can replicate the issue repeatedly with a 100%
error rate.

Regards

Colin Dawson
www.cjdawson.com