Solved

missing SQL Server 2000 Developer Edition CD

Posted on 2008-06-15
3
604 Views
Last Modified: 2008-09-10
I need to import 3 million rows to a table in a database NOW, and my copy of "SQL Server 2000 Developer Edition" needs to be installed on my new computer. But I can't find my CD - I still have my product ID and the original box.
MS doesn't offer the option to purchase and download the software (which I would do if I could) - I need to get a solution NOW. I really just need enterprise manager. I've tried downloading a few other products, but it isn't working well. Some give errors (such as Vale software's MSDE and my legitimate copy of MS Access). Some take too long (such as Aqua's product - 54 hours estimate).
Is there a place to get a copy of the CD image and I'll enter my product key? Or a place to buy and download the 2005 version legally? Otherwise, I have to try to order the CD online and waiit for delivery.
0
Comment
Question by:Lev Seltzer
3 Comments
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 50 total points
ID: 21789319
the database does exist already?
so, use that instance...

now, where do those 3 million rows come from?
0
 
LVL 51

Accepted Solution

by:
Mark Wills earned 450 total points
ID: 21789323
You can download SQL Server Express with Advanced Services for free, or the trial versions and sort out the licensing later... access via : : http://technet.microsoft.com/en-us/sqlserver/bb671245.aspx


or if 2000, could try : http://www.microsoft.com/downloads/details.aspx?FamilyID=d20ba6e1-f44c-4781-a6bb-f60e02dc1335&DisplayLang=en
and check out : http://technet.microsoft.com/en-us/sqlserver/bb671137.aspx


if all you need is Enterprise Manager, then I am told that sql server express Management Studio will work with 2000 databases, the express version is also free...
http://www.microsoft.com/downloads/details.aspx?FamilyID=6053c6f8-82c8-479c-b25b-9aca13141c9e&DisplayLang=en

but probably best if you are writing code to import is the sql server express with advanced services :
http://www.microsoft.com/downloads/details.aspx?FamilyID=5b5528b9-13e1-4db9-a3fc-82116d598c3d&DisplayLang=en
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now