Hello all,


I have created a link server and trying to update a table residing in a database of that server.

Note: This table does not has any key/index defined on it.

i am trying to update this table by using a join with local table.

for example:

local server : server1
database: localdb
table: material_mst

linkserver : server2
database : linkdb
table : mat_mst

update sql is like this

update server2.linkdb.dbo.mat_mst
set mat_nm = b.mat_nm
from server2.linkdb.dbo.mat_mst a,material_mst b
where a.mat_no = b.material_no

this generates an error :

Error 7306
Severity Level 16
Message Text
Could not open table 'server2.linkdb.dbo.mat_mst' from OLE DB provider 'SQLOLEDB'


Please suggest what can i do except creating index/key on target table.

Note: i m using SQL 2000 server and both server has different collation.
Local Server - Latin , Link Server - Thai


Nitin Paliwal