Solved

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

Posted on 2011-02-20
2
612 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 32

Accepted Solution

by:
Ephraim Wangoya 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

617 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