Insert the information inside the database table of one server in to the table of your database of a

-Establish a connection for the server

EXECSP_ADDLINKEDSERVER 'AA', '', 'SQLOLEDB', BB '-AA may be the server link name, BB is the server name or server IP address;

EXECSP_ADDLINKEDSRVLOGIN 'AA', 'FALSE', NULL, 'SA', '123456'-AA is the server hyperlink name, SA would be the username from the hyperlink server database, and '123456' would be the password on the hyperlink server database;

GO

--Read the data inside the user data table with the DD database within the AA server and insert it into the user details table of the EE server CC database INSERTINTO [EE]. [CC]. [Dbo]. [INFO_USER]

Choose * FROM [AA]. [DD]. [Dbo]. [INFO_ file recovery ]