Home Forums SQL Server 7,2000 T-SQL SQL Query - Join on a table in another database? RE: SQL Query - Join on a table in another database?

  • I'd set an view up on the linked server, select a, b, c from newserver.newdb.newtable, and then use the view for updates. That way you won't have to change much code as the table moves to a new server, or even comes back to another database on this server.