I am using a Linked server to get data from a remote server. I am able to connect to the linked server and retrieve using select command from all tables from the desired database. However there is one table which when I try to connect throws up the following error:
Msg 7319, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI" for linked server "SERVER2" returned a "NON-CLUSTERED and NOT INTEGRATED" index "tdate" with the incorrect bookmark ordinal 0.
tdate is a nvarchar(50) type column and is not the primary index.
Any help would be appriciated to resolve this issue.