SQL Server Performance Forum – Threads Archive

SQL UPDATE across 2 databases

I want to write an update to a database from DB 1 to DB 2 Where DB1 is located on another server fe DB1 server 1 Customer Table
Field CustAmount to DB2 Server 2
Customer table
Field CustAmount So that the values from DB1 are updated in DB2 How can I write such an update command? With regards Thanks

---

You can use the same logic that we posted for your other query. You need to create a linked server to connect to another server and modify the query. Look BOL for creating Linked Server. Thanks, Name
———
Dilli Grg (1 row(s) affected)

---

]]>