SQL Server Performance Forum – Threads Archive
just like Oracle’s Database link?
Hi ALL, I would like to INSER, UPDATE, DELETE in db2 which in other machine2Being in mechine1 db1. This just like oracle#%92s database link is there any way in MSSQL serve Regards,
Srini
hi,<br />yes obviously you can do this with the help of sp_addlinkedserver ‘servername’ to add server then<br />just e.g. for select <i></i><b> <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">select cols from server.db.user.table<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"></b> .. as this you can perform DML too.<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
Hi,
Many thanks for ur Reply Can u do like this : example i loged in to the svr01 database is TEST01 1. insert into emp select * from svr02.TEST.user01.emp where [email protected]
2. update svr02.TEST.user01.emp set ename=’SRINI’ where applid=101
Regards
Srini
sure you can do this
Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami
By default you must use 4 part query name in linked server environment. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>