>Thanks, I added a second dot. So, I was able to obtain something more. I checked for the instance and this is not defined. I can see it in the property of the server. So, I tried:
>
>
>UPDATE Client
> SET Address=o.Address FROM Client m
> JOIN MyOtherServer..MyDatabase.Client o on o.Numero=m.Numero
>
>
>...and now I get:
>
>The OLE DB provider "SQLNCLI10" for linked server "MyOtherServer" does not contain the table ""MyDatabase"."Client"". The table either does not exist or the current user does not have permissions on that table.
>
>However, the table does exist as the linked server shows it under.
The double dot is in the wrong place, remember the order is Server.Database.Schema.Table, so MyOtherServer.MyDatabase..Client should do the trick
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
