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.