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
 How to access a table from one server to another?

Author  Topic 

mageshks
Yak Posting Veteran

59 Posts

Posted - 2006-10-30 : 06:48:36
Hi,

Lets say i have 2 servers in my Computer. Local server and a common server (network) and i want to copy a table from common server to my local server . How to do that?.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-30 : 06:54:20
Complete table with DDL, or do you mean all the DATA in the table?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-10-30 : 08:27:54
Read about these in sql server help file
1 DTS
2 Import/Export Wizard
3 Linked Server

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-30 : 08:32:22
Don't forget about replication.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -