-
Distributed Query and Linked Servers not working
I am trying to write a distributed query that accesses two tables that exist on two different servers. I have set up a linked server on the machine I am running the query on. When I run the query I get this message:
Server: Msg 7319, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'Alert__Company_D' with incorrect bookmark ordinal 0.
I have tried various tables and they all give this message but with different indexes. The query works fine on the other server. There is no explanation of message 7319 online or in Books Online.
Can anyone help?
Thanks John.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|