SELECT * FROM [<server_name,sysname,(local)><instance_name,sysname,\
Example: SELECT Name, Address FROM RMTSERVER.AdventureWorks.Person.Address
SELECT * FROM CUSTOMERACCESS...Customer
The DTC Explained
Server uses the Distributed Transaction Coordinator (DTC) to handle
multiple-server transactions, commits, and rollbacks. The DTC server
uses a two-phase commit schema for multiple-server transactions. Here
are the steps.
Server is sent a prepare to commit message.
Server performs the first phase of the commit, verifying that it is capable of committing the transaction.
Server replies when it has finished preparing for the commit.
After server has responded positively to the prepare to commit message, the actual commit message is sent to each server.
DTC is required only when remote updates are occurring in the remote server.
There are three catalog views related to Linked Servers: sys.linked_logins, sys.servers, and sys.remote_logins. The most frequently used catalog view is sys.servers.
SELECT * from sys.servers
WHERE is_linked = 1
The preceding query will return the list of linked servers attached to a SQL server.