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