>Hello All,
>
>Here is a problem i have faced with sql server when i m trying to update data on linked server.
>
>note: i m using SQL 2000 server.
> Both server (local) and link server having different collation.
>
>details of the problem are as follows -
>
>
>link server name : server1
>database on link server : db1
>table

hah?