Copy a table from one DB to another

On the destination database, run:

exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure

 

Run copy:

INSERT INTO [DEV].[dbo].[tblUser]
   ([ID]
   ,[Name])
SELECT
    *
FROM
    OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.1.103,3422;User ID=sa;Password=YourPWD;').databaseName.dbo.tableName

转载于:https://www.cnblogs.com/yuvu/archive/2012/09/12/2681792.html