>>You're missing schema. MyDatabase.dbo.Client o
>
>This dbo thing is something I never use. For that command, however, it was necessary. Once I read Vladimir's message combined with the technical advices of Hugo, I was able to have it working.
>
>>Also, I would do the other way around. If you need to update table in one DB, I will use the other table (from other server) as linked server.
>>
>>Alternatively, you may want to look into OPENROWSOURCE syntax in help.
>
>Thanks

I read it somewhere that two parts name convention will be a requirement in the future versions of SQL Server. So, you may want to start writing dbo.myTableName everywhere. Besides, it helps for performance.