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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Insert Data to diff Server table

Author  Topic 

ankujkumarg
Starting Member

2 Posts

Posted - 2012-06-26 : 08:15:50
Hi,
Is there a way of insert data from one server table to another server table?
Plz give me your valuable advice ASAP.
Thanks in Advance.


ankujverma

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2012-06-26 : 08:18:47
Have a look at Linked Server in SQL Server help file

Madhivanan

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

ankujkumarg
Starting Member

2 Posts

Posted - 2012-06-26 : 08:22:38
i'm wanting insert data through stored procedure

ankujverma
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2012-07-02 : 02:12:31
Yes you can do it via linked server or using OPENQUERY

Madhivanan

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

- Advertisement -