I'm trying to update a table on 1 server from another on another server.
How do I reference them / alias them
The following does not work
UPDATE [server1].[db1].dbo.tRep A SET IS_ACTIVE = 1
FROM [server2].[db2].dbo.REP B WHERE A.REPNO = B.REPNO
How do I alias the db/tables?