sqlserver跨服务器查询

两个sqlserver数据库在不同的服务器上如何插入数据哪？

EXEC sp_configure 'show advanced options', 1  
RECONFIGURE 
EXEC sp_configure 'Ad Hoc Distributed Queries', 1  
RECONFIGURE  

INSERT INTO [a].[dbo].[at]
           ([at1]
           ,[at2]
           ,[at3])
     SELECT [bt1]
           ,[bt2]
           ,[bt3]
       FROM OPENROWSET('SQLNCLI','Server=ip;PWD=pwd;UID=uid;DataBase=db','SELECT [bt1], [bt2], [bt3], [bt4] FROM [bt]') AS b
      WHERE [bt3] = 1 AND bt4 < GETDATE() 
            AND NOT EXISTS (SELECT 1 FROM [a].[dbo].[at] a WHERE a.at1 = b.bt1 ) 
   ORDER BY [at1] ASC

EXEC sp_configure 'Ad Hoc Distributed Queries',0  
RECONFIGURE 
EXEC sp_configure 'show advanced options',0  
RECONFIGURE