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.
| Author |
Topic |
|
subhaoviya
Posting Yak Master
135 Posts |
 Posted - 2012-12-06 : 04:22:24
|
| Hi, I am having 2 servers S1 and S2, set that s2 as linked server in S1 and created synonyms in DB1 in S1 for accessing T1 of S2.I able to do the select query but not able to update the table records from s1. How we can acheive this? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-06 : 08:37:58
|
| Duplicate threadhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=181236 |
 |
|
|
|
|
|
update table via Linked server.