SQL 2000 SP4 and SQL 2005 Express Co-Exist?

[wajackson]

I recently installed SQL 2005 Express on a SBS 2003 Server that is running SQL 2000.

Here's the events and the question I need help with:

1) After the successful installation of SQL 2005 Express and the Management Studio, I attached an existing 2000 Database.

2) I created a new Database in the Management Studio

3) I created a SQL script that created a 'Copy' of a Table in the SQL 2000 database and it ran successfully.

4) I detached the SQL 2000 Database from the Management Studio

5) I attempted to Register the SQL 2000 Database with the Enterprise Manager (as it had been before) and now the Enterprise Manager cannot register 'attach' the database.

Any ideas why?

Does attaching, accessing (not writing), to the SQL 2000 Database to the SQL 2005 Management Studio 'migrate' or 'upgrade' the 2000 Database? or somehow else change it to where Enterprise Manager no longer recognizes it?

Help?

[wajackson]

P.S.

The database programmer for the 'other' application using SQL 2000 swears that simply installing SQL 2005 Express 'upgraded' his SQL 2000 database. Is this accurate?

Thanks

[almaz]

When you attach an old database to newer SQL Server, it automatically upgrades it to the latest format. In your case you attached database in SQL Server 2000 format to SQL Server 2005, so it had been converted to SQL Server 2005 format. Now you cannot attach it to previous version.