Updating Table With Data From Another Server.

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)

Updating Table With Data From Another Server.

Author

Topic

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2009-02-26 : 10:29:11

Hi Guys

I have two tables both on different servers.

The thing that I am trying to do is update a table from Server 1 with data from a table on Server 2.

Is this possible to do?

Thanks!!!

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-26 : 10:32:41

Create Linked server and Use Four-part naming convention like :

Servername.database.schema.tablename.

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2009-02-26 : 13:28:00

Hey

Thanks for that, it works perfectly!!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources