Showing posts with label links. Show all posts
Showing posts with label links. Show all posts

Sunday, 11 March 2012

Connect from Databases in 1st Instance to Databases in 2nd Instance

This is the scenario. Is it possible to create views or something (like Oracle DB Links) in a database in Instance 1 which can show data from another database in 2nd Instance ?
I want to do this to create reports.you want to create a linked server with sp_addlinkedserver|||thanks. it worked.