November 29, 2001 at 9:43 am
When I linked two SQL servers (both SQL Server 2000 with sp1) and execute simple select statement to a table from linked server, then I get error 7319. Table has 2 indexes, when I delete one, the error disappear.
The same error happens when I try to create a view on linked server from my server. But, if I create the same view on the server (which is later linked) and execute the same select statement to a view from a linked server, then everything works just fine. Ofcourse, I use 4-part names.
I get this error nomatter which server I try to connect to. And this server was upgraded from SQL 7.0
Other server is working just fine, no errors.
Any idea?
November 29, 2001 at 6:44 pm
I use linked servers quite a bit, never seen this particular issue (or much of any other!). Have you checked MSDN to see if an Q articles? What are the indexes, how many/type columns?
Andy
November 29, 2001 at 11:00 pm
Yes, and I didn't found any limitation like that on view. And I don't think that it is the problem of numbers of indexes. If I change the roles of the servers and the first one is linked server, everything is OK.
December 6, 2001 at 1:23 am
I set IndexAsAccessPath to 0 and now it's working just fine (advice from Bart Duncan-MS)
December 6, 2001 at 5:00 am
Interesting - thanks for the follow up!
Andy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy