Re: Variable server names

Tech-Archive recommends: Speed Up your PC by fixing your registry

I assume you have a linked server to the other server? If that's the
case, you can use a synonym for each table...

CREATE SYNONYM
mySyn
FOR
MyDatabase.MySchema.MyTable

....

SELECT * FROM mySyn

Eric Isaacs
.