openquery issue in SQL Server

I am using SQL Server 2008 (let us call this source database server in this question discussion), and in SSMS, I 开发者_运维技巧have created a linked server to another SQL Server 2008 database (let us call this destination database server in this question discussion).

When I issue statement -- select * from [linked server name].[database name].[dbo].[table name], error will be returned,

Linked server "ZS" The OLE DB access interface "SQLNCLI10" returned "NON-CLUSTERED and NOT
INTEGRATED "Index" ix_foo_basic_info_nf ", which is incorrect bookmark ordinal 0.

When I issue statement -- select * from openquery([linked server name],'select * from [table name]'), there will be no errors, any ideas what is wrong?

thanks in advance, George

Is the Index As Access Path option set for the Linked Server Provider? If so, try removing this and see if it fixes the problem.