Did you try to run a query against server2? Something like

SELECT * FROM server2.linkdb.dbo.mat_mst

>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