Linked Servers

From RapidSQL
Jump to: navigation, search

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

Drop

Extract

Migrate

Report