Run SQL query on different servers WITHOUT linked servers
Posted on 2009-02-20
OK, I have two different databases, on two different SQL servers. I am not allowed to link the servers on the backend because my company feels it is a security vulnerability.
What can I do (even if it is not a glammerous method) to ultimately run a SELECT query displaying results with the data from both of these tables combined in ASP like you can in MS Access?
The current user does have authentication rights on both servers and databases.