Sunday, March 25, 2012

Access Data From Multiple SqlSever Instances

Hi
I am having two SQL Server instances installed at two different systems and want to fetch data from both of them in a sigle query with joins. Somebody suggested that I need to link up the sql server instances at the admin level. If you have an idea about the process of linkng multiple sql server instances kindly convey it to me.

For Details of the discussion kindly follow the undergiven link

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=138563&SiteID=1

Thanks

How to add linked servers is described in the Books Online topic for sp_addlinkedserver and the related topics. See ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/fed3adb0-4c15-4a1a-8acd-1b184aff558f.htm.

|||Thank you Steven, I'll check it up.

No comments:

Post a Comment