Copy Table
March 26th, 2014 2:39pm
You may use Export/Import Wizard in SQL Server.
Free Windows Admin Tool Kit Click here and download it now
March 26th, 2014 2:44pm
Just the table design or including the data?
March 26th, 2014 3:02pm
Hi,
You can use linked servers. Add a link server and use the following query:
select * into [target_table] from [source_server].[source_database].[dbo].[source_table]
For more information on linked servers, please refer http://msdn.microsoft.com/en-us/library/ff772782.aspx
-Vatsalya
Free Windows Admin Tool Kit Click here and download it now
March 27th, 2014 2:31am