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?