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.

No comments:

Post a Comment