Chapter IV.6. Developing Remote Applications
Remote applications are commonly used when interacting with SQL Server. In other words, SQL Server is rarely hosted on the same system as the applications that use them. Instead, the applications access the data remotely.
Additionally, tools are available that allow you to access data from the SQL Server to just any other data source. This allows applications to access a remote SQL Server which in turn accesses another remote data source. The three primary tools you'll use are OPENDATASOURCE, OPENROWSET, and linked servers.
Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
