I have a requirement to do SELECTs on a number
of different databases that are not all on the same
SQL Server installation (2 servers, 6 databases).
I don't have enough disk space to replicate all the
databases into one big database.
Can I do connections in Transact-SQL to the databases?
What are my alternatives?
thanks in advance...