Sql Server Linked Server

Question

I have two sql server S1(2008) and S2(2005).

S2 is added to S1 as linked server.

S2 have a table Product.

When I try to run the code

select ProductID from Product

I get the error:

Location:    rmt_meta.cpp:347
Expression:  fFalse
SPID:        71
Process ID:  3828
Description:     Unknown column in remote index! Skipping.

Any idea?

Answer 1

It Seems that column name is diffrent or not exists on linked server.

Try to run select * from product & check all available columns.

---

Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!

Answer 2

Is there any blobs cols in Product table? If yes then please review http://support.microsoft.com/kb/2644794/.

Answer 3

Hi sickpogo,

Please use SQL Server S1 to run the code to see it would be OK.  There may be something wrong with the table.
SELECR ProductID FROM Product

If you have any problem, please feel free to let me know.

Thanks,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.