Linked server error 7319 only for one table.

• R.K Sarangi

  SSC Enthusiast

  Points: 167

  More actions

  October 26, 2013 at 7:41 am

  #279308

  Hi,

  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.

  regards,

  rakesh