exec sp_addlinkedserver 'ITSV ', ' ', 'SQLOLEDB ', '192.168.1.100'
exec sp_addlinkedsrvlogin 'ITSV ', 'false ',null, 'sa ', '123456'
select * from ITSV.Express_Order.dbo.ErrorMsg
select id,errmsg from ITSV.Express_Order.dbo.ErrorMsg
delete ITSV.Express_Order.dbo.ErrorMsg
Insert into [Express139_Order].[dbo].[ErrorMsg] (errmsg,UserID,errDate) (select errmsg,UserID,errDate from ITSV.Express_Order.dbo.ErrorMsg)
exec sp_dropserver 'ITSV ', 'droplogins '
http://blog.csdn.net/wobuwei/article/details/4043785 引用自