About SQL Server Remote cross-Library modification data

Today encountered a need to modify the remote server data, how to directly modify, and collapse library, cross-Library simple, directly add the database name, remote words need to create a linked server, the following steps:

--创建链接服务器  exec sp_addlinkedserver    ‘SDDJG ‘ ,  ‘ ‘ ,  ‘SQLOLEDB ‘ ,  ‘远程服务器名或ip地址 ‘ exec sp_addlinkedsrvlogin   ‘SDDJG ‘ ,  ‘false ‘ , null ,  ‘用户名 ‘ ,  ‘密码 ‘--whether the test data can query the select * from SDDJG. Database name. Table Name --本地导入示例  select *  into 表  fromSddjg .数据库名.表名  In fact, if the link succeeds, the operation and the local write SQL is basically the same, the remote database, plus the link database name. 以后不再使用时删除链接服务器，可以在过程后面执行此过程  exec sp_dropserver   ‘SDDJG  ‘ ,  ‘droplogins ‘

About SQL Server Remote cross-Library modification data