Linked Servers are an interesting technology in SQL Server to allow remote access from within the database to external data sources. They can be a boon in a heterogenous environment with other Oracle, DB2, etc. data sources. But they can also help in a smaller scale against those "hidden" datasources like Excel or Access. New Author Krishna.
Read more...
By
Krishna Sonti
2007/06/08 (first posted: 2004/06/02)
|
Source:
SQLServerCentral.com
|
Category:
Distributed Queries
