How do I select a SQL server?

Question

The company I work for uses a bunch of different SQL servers and I was wondering how to select a different SQL server in the same script.

For example, I want to select data from a table on a database in server 1 and using that data to get data from another table on a database in server 2. I tried googling the solution but I couldn't find anything relevant to my problem.

Thanks in advance.

Answer 1

You can set them up as linked servers.

http://msdn.microsoft.com/en-us/library/aa560998(v=bts.10).aspx

then you syntax will be

SERVERALIAS.DBNAME.owner.TABLE

Answer 2

Use fully qualified names (i.e. select * from [server].[database].[owner].[tablename])

Also, be sure to setup those servers as linked servers. There are several articles online how to do this.