Linked Servers

Go Up to [[Supported Objects{{#if:||{{{2}}}}}]]

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.

Linked servers enable you to:

• 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:

<source lang="sql"> SET ANSI_NULLS ON GO SET ANSI_WARNINGS ON GO </source>

Creating and editing

• Linked Servers Wizard (SQL Server) and Linked Servers Editor (SQL Server)

DBMS platform availability and object actions/operations supported

The following table 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.

Object Action	SQL SVR
Drop	✓
Extract	✓
Migrate	✓
Report	✓