CODEWITHSUNDEEP
t-sqlsql-server-2008linked-serveropenquery
George2
George2

Reputation: 45771

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

Upvotes: 1

Views: 2194

Answers (1)

starskythehutch
starskythehutch

Reputation: 3338

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.

Upvotes: 1

Related Questions