DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
Query And Join Tables Across Server Instances.
Use the following to query or join tables on remote servers. The query must be executed on a system running SQL Server, but the remote system can be pretty much anything an ODBC driver exists for:
select * from OpenDataSource(â€™SQLOLEDBâ€˜,â€™Data Source=server.asdf.com;User ID=yourusername;Password=yourpasswordâ€˜).somedatabase.dbo.sometable;