multiple options
1. Use export/import wizard and do table copy to new database
2. Create a linked server connection between servers from targetdb to sourcedb and use query like
USE [TargetDB]
SELECT * INTO TargetTable FROM [SourceLinkedServer].SourceDB.dbo.Table
3. use OPENROWSET and no need of linked server setup
USE [TargetDB]
SELECT * INTO TargetTable FROM OPENROWSET('SQLNCL1','Server=sourceserver;Trusted_Connection=yes;',
'SELECT * FROM SourceTable') AS a;
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Copy table from one server to other
Posted - 2011-12-16 : 02:02:22
