Query Multiple Server 1

[dpwsmw]

I have 2 seperate Servers, and would like to know the steps to connect both of them and run a insert statement from one server.table.row to server1.table.row

Do you use a Join first? I need a little feed back thanks

 

[SQLDenis]

first create a linked server
then insert into server1.dbname.dbo.tableName
select * from server2.dbname.dbo.tableName

lookup Linked Servers in BOL

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/