Over a million developers have joined DZone.

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;

The best of DZone straight to your inbox.

Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}