Solved

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

Posted on 2011-02-20
2
607 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:ShayB_CGS
2 Comments
 
LVL 32

Accepted Solution

by:
ewangoya earned 125 total points
ID: 34940100

Try linking the server to your SQL 2008R2 Express server

http://msdn.microsoft.com/en-us/library/ff772782.aspx#SSMSProcedure
0
 
LVL 1

Author Closing Comment

by:ShayB_CGS
ID: 34945689
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:

http://support.microsoft.com/kb/906954

Thanks again
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now