Establish a linked server between SQL Server

Open SSMs, server object--linked server, right-click on "New Linked server", General options, enter linked server name or IP address, server type select SQL Server

Under Security Options, select the options below, enter your account and password, then click OK.

In SSMs, the server object-the linked server-will appear with the name of the linked server you just established.

Assume that the linked server name you just established is 192.168.10.10

Test:

Select Top Ten * from "192.168.10.10". Test.dbo.test

To view the first 10 rows of data from the test table in the test database.

I cannot copy a table to a linked server in my own local instance, such as:

SELECT * into "192.168.10.10". Test.dbo.test

From Test1.dbo.test1 (this is the database and table for my local instance)

The error is similar:

The number of prefixes that are contained exceeds the maximum value. The maximum value is 2

For more information, refer to technet:http://technet.microsoft.com/zh-cn/library/ff772782

Establish a linked server between SQL Server and SSMs in connection with the database engine, the server name input remote SQL Server IP or name functionality is the same, it is estimated that only the details and interface are different.

The primary purpose of a linked server should be to connect between different databases.

Previously done in SQL Server to establish a linked server to Sysbase, has been successful. Later deleted after the start again and want to record, inexplicably failed again, had to drop!

Sybase's database, it feels a little awkward.

Subsequent visits between SQL Server and Oracle should be done.