Linked Servers
Go Up to Supported Objects
Linked servers let you create links to OLE DB data sources. With a linked server you can execute commands against OLE DB data sources on different servers. Using linked servers you can:
- Access remote servers
- Issue enterprise-wide distributed queries, updates, commands, and transactions.
Distributed Queries
Before you run a distributed query, write the following as the first statement of your SQL script:
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
Creating and editing
DBMS platform availability and object actions/operations supported
The table below lists the platforms on which this object type is available. It also lists the object actions available against objects of this type For an introduction to object actions and details on usage of specific actions, see Object actions.
SQL SVR | |
---|---|
✓ | |
✓ | |
✓ | |
✓ |