I am trying to write a distributed query that accesses two tables that exist on two different servers. I have set up a linked server on the machine I am running the query on. When I run the query I get this message:

Server: Msg 7319, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'Alert__Company_D' with incorrect bookmark ordinal 0.

I have tried various tables and they all give this message but with different indexes. The query works fine on the other server. There is no explanation of message 7319 online or in Books Online.

Can anyone help?

Thanks John.