Connect to multiple SQL Servers in one Query

Toad for SQL Server
1

I have a query that needs to combine data from tables in two different SQL servers. I can do this in Toad Data Point by simply prepending the server name before the database.

server-name.schema.table.field

But when I copy the same query from Data Point to Toad SQL server, the query fails, and cannot find one of the tables.

Is this a limitation of Toad for SQL server and the reason people must purchase Data Point for these types of multiple server queries?

Thank you in advance.

2

Your different servers have to be linked in order to do this. use sp_addlinkedserver and you will be able to do what you wish with a little more finagling.

3

OK. I don't have the privileges to link a server. Now I understand why people use Toad Data Point. That is designed for this scenario.

Thank you for the information.