title: How can I open a SQL Server 2000 database in SQL Server 2008 Express?
body: <p>A friend recently asked me to help him to change an application to allow multiple instances connecting to the same back end database. However, he has very limited understanding toward the inner work of the application or CS in general, and the guy who had developed the application for him has left.  </p>
  
  <p>My guess is that it is possible to get it done by making some simple changes to the application's database connection properties. The problem is that I have no idea how the database was set up. A note left by the previous developer mentioned that the database was created in SQL Server 2000. I do not have SQL Server 2000 around though. Is it possible at all to open/migrate the SQL Server 2000 database to SQL Server 2008 Express, and if so, how can I do it? If not, what the reasonable approach for the DB migration?</p>
  
  <p>Thanks a lot for your help!</p>
  
  <p>--Angler Y.</p>