Toad World® Forums

Connect to multiple SQL Servers in one Query

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.

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.

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.