openquery issue in SQL Server
- by George2
Hello everyone,
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