Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked server error 7319 only for one table. Expand / Collapse
Author
Message
Posted Saturday, October 26, 2013 7:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 27, 2013 11:32 AM
Points: 1, Visits: 3
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
Post #1508659
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse