domingo, 5 de agosto de 2012 17:43
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:
Process ID: 3828
Description: Unknown column in remote index! Skipping.
Todas as Respostas
segunda-feira, 6 de agosto de 2012 05:08
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!
- Marcado como Resposta Maggie LuoMicrosoft Contingent Staff, Moderator terça-feira, 21 de agosto de 2012 20:07
segunda-feira, 6 de agosto de 2012 08:24Is there any blobs cols in Product table? If yes then please review http://support.microsoft.com/kb/2644794/.
terça-feira, 7 de agosto de 2012 09:17Moderador
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.
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.