Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Copying Table and Data

Author  Topic 

Steve95
Starting Member

19 Posts

Posted - 2007-05-01 : 08:47:47
Hi All

Iam using sql 2005 and am new to it, I want to copy a table and data from server to another, how is this possible?

Many Thanks in advance....

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-01 : 09:59:53
Use import/export wizard in SSMS, or build an SSIS package.
Go to Top of Page

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-05-01 : 11:57:12
How many rows do you have in the table?

Dinakar Nethi
SQL Server MVP
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/
Go to Top of Page
   

- Advertisement -