SQL Server and OLE DB Heterogeneous Queries

By Bill Graziano on 18 July 2000 | Tags: Application Design

The August Edition of MSDN also has an article on using OLE DB for heterogeous queries. It shows how to create a linked server and execute queries against it.

Link: SQL Server and OLE DB Heterogeneous Queries

Related Articles

Application Locks (or Mutexes) in SQL Server 2005 (7 January 2008)

What I Wish Developers Knew About SQL Server (Presentation) (11 October 2007)

Multiple Active Result Sets (MARS) – Transactions and Debugging (17 June 2007)

Multiple Active Result Sets (MARS) (3 April 2007)

How SQL Server 2005 Enables Service-Oriented Database Architectures (8 September 2006)

Presentation: What I Wish Developers Knew About SQL Server (17 November 2005)

GeoCoding with SQL Server and Google (8 August 2005)

How to Asynchronously Execute a DTS package from ASP or ASP.NET (27 March 2005)

Other Recent Forum Posts

SQL Server 2019 CU vs GDR update which one is correct? (4d)

Need To Generate Shift Rotation Weekwise Rather 7 Day Wise For The Yearmonth 202508 (37d)

Improving update statistics process for 6 big tables (46d)

Peer to Peer Replication is not working between 2 different machines (46d)

SQL HELP in SSMS: The query references an object that is not supported in distributed processing mode (81d)

Subscription sends report with data to one user but empty report to other users (83d)

Pivot Tables in SQL (90d)

Can't restore backup; SSMS says my user account directory is empty (91d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site