Executing Queries from SQL 2000 to SQL 2005 Linked Server Throws Error on Indexed Tables
Posted on 2014-04-01
I have a SQL 2005 R2 server that I want to link to from a SQL 2000 server running SP4. I can create the linked server okay, and I can query any table in the database that does not have an index. For the tables that do, however, (most of them) I get the following error when I try to query data from it:
SELECT * FROM LinkedServerName.DatabaseName.dbo.Item
Server: Msg 7319, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'IX_IMA_CustItemID' with incorrect bookmark ordinal 0.
OLE DB error trace [Non-interface error: OLE/DB provider returned an invalid bookmark ordinal from the index rowset.].