472,961 Members | 1,437 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,961 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?

Mar 1 '07 #1
2 3474

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?

Mar 1 '07 #2
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

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

Similar topics

by: ik | last post by:
ERROR after uninstalling SQL Server 2005 Express I get this message, SQLDMO has not been registered. Please re-run your setupand contact your system administrator. GREAT!!! ReInstalled SQL...
by: Dan Sikorsky | last post by:
Can I use SQLServer 2000 with ASP.NET 2.0 instead of SQLServer 2005, and use the .Net 2.0 Membership functionality? I've setup my Login page, controls, etc., and now it's time to use the Web...
by: FreeToGolfAndSki | last post by:
I'm thinking of migrating our 12 user SQL 2000 db to SQL 2005 Express. The db is about 2 gb. Does anyone know if there is a no of users or db size or other restrictions on SQL 2005 Express. How...
by: Jack | last post by:
Hello, I had SQL2000 server running fine on the windows 2003 box. I then installed SQL 2005 Express. They both worked together fine. I then uninstalled SQL 2005 Express and installed SQL 2005...
by: HC | last post by:
I posted this in one of the VB forums but I'm starting to think it might be more appropriate to have it here, since it really seems to be a SQL server (MSDE/Express 2005) problem: Hey, all, I...
by: Mo | last post by:
Hello all, I'm trying to set up an access 2000 .adp project connecting to a SQL server 2005 database. I can set up the connection ok, but once I have completed the setup process, I get the...
by: bergy | last post by:
Just wondering if this is possible, I'm coding this application that will run on a network with a SQL Server 2000, however each workstation (notebook computers in this case) will need to copy some of...
by: =?Utf-8?B?Smlt?= | last post by:
I currently have three new websites under development and all need ASP.NET 2.0 type functionality such as Membership and data access. I currently use FrontPage 2003 as my preferred website...
by: Grey Alien | last post by:
I have an ASP.Net website that was developed using SQL Server 2000. I want to 'port' it to use SQL Server Express, since I don't have SQL Server 2000 (besides my db is less than 1GB). Questions:...
by: =?Utf-8?B?TUVH?= | last post by:
I've installed VB Express 2005 and SQL Server 2005 Express on a workstation that had SQL 2000 on it. I can only get VB Express to connect to the SQL Server 2005. From other groups I read that...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

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.