• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 620
  • Last Modified:

How to link/query SQL 2000 data from SQL Express 2008 R2

I have a production server with a legacy application which requires Microsoft SQL 2000.  I have written several asp.net based reports that query this data (read only).  Some of the functionality that I would like to add to our reporting would benefit from features of a more modern version of SQL (i.e. Multiple Active Result Sets).  I have setup a second server with SQL Express 2008 R2 and was considering replicating a copy of the data from the 2000 server to the 2008 server and updating it regularly.  Any suggestions on a better solution?  I cannot alter the 2000 server.  Is it possible to link the tables in 2008 so I can access the 2000 data and utilize the added features of 2008?
1 Solution
Ephraim WangoyaCommented:

Try linking the server to your SQL 2008R2 Express server

ShayB_CGSAuthor Commented:
Thanks for the link.  That was the instruction I was having trouble finding.  After configuring the Linked Server I had an additional error and had to also follow this:


Thanks again
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now