471,067 Members | 1,559 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,067 software developers and data experts.

SQL 2000 SP4 and SQL 2005 Express Co-Exist?

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?
Mar 1 '07 #1
2 3419
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
Mar 1 '07 #2
almaz
168 Expert 100+
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.
Mar 2 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by FreeToGolfAndSki | last post: by
5 posts views Thread by Mo | last post: by
2 posts views Thread by =?Utf-8?B?Smlt?= | last post: by
6 posts views Thread by Grey Alien | last post: by
3 posts views Thread by =?Utf-8?B?TUVH?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.