After Sql 2005 Install, Sql 2000 Still There

pbd22

Hi.

I just downloaded and installed Sql 2005 from the MS site.
I see that my instance of Sql 2000 is still on the same computer.
I assumed that Sql 2005 would upgrade but it didnt. Should I
simply delete my instance of 2000 or will this cause complications?
Sorry - newbie question.

Mar 30 '07 #1

Subscribe Post Reply

1724

Erland Sommarskog

pbd22 (du*****@gmail.com) writes:

I just downloaded and installed Sql 2005 from the MS site.
I see that my instance of Sql 2000 is still on the same computer.
I assumed that Sql 2005 would upgrade but it didnt. Should I
simply delete my instance of 2000 or will this cause complications?

That depends on how you opted to do your installation: as a new instance
or an upgrade. Since you say that you downloaded SQL 2005 from MS,
I assume that you installed SQL Express, which by default is installed
as a named instance, SQLEXPRESS.

I would keep both instances, as you may want to compare SQL 2005 to
SQL 2000.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Mar 30 '07 #2

by: Philip Leduc | last post by:

Hi there, I am a MS Access VBA programmer trying to get my feet wet using VB.net / SQL server. I have SLQ 2000/visual studio 2003 loaded and did get a SQL2005/visual studio 2005 software...

.NET Framework

Connecting Sql Server 2005 from ASP?

by: MVChauhan | last post by:

Hi We are planning to move over to SQL Server 2005 in near future. At the moment Website is on a seperate server then the Database. OS for both the server is Window 2003 and currently our data...

Microsoft SQL Server

SQL Server Management Studio can't 'see' the 2005 engine?? But can see 2000 ?!?

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...

Microsoft SQL Server

installing sql 2000 & 2005 side by side

by: steve1rm | last post by:

Hello, I have a version of 2000 already installed which I still need. However, I recently installed 2005, something did not install right, so I was forced to de-install it. However, when I go to...

Microsoft SQL Server

Using MS SQL Server 2005 Enterprise Manager with MS SQL Server 2000

by: Alex | last post by:

Hi Everyone, Most of our MS SQL Servers are still running on SQL 2000, but being I will soon be upgrading my workstation to Vista Business I'd like to install MS SQL 2005 Enterprise Manager to...

Microsoft SQL Server

Migrating to 2005, need advice

by: tootsuite | last post by:

Help. I have been tasked with upgrading a 2000 instance to 2005. I have actually done this before, but it was a long time ago, and I didn't do it alone. Now, the sitation is little different, and...

Microsoft SQL Server

MSSQL 2000 and MSSQL 2005 servers run in the same desktop machine

by: Derftics | last post by:

Hi Guys, Is there anyone who have tried installing MSSQL 2000 and MSSQL 2005 servers in one desktop computer? I have tried using MSDE and successfully install the MSSQL 2000 server but when I...

Microsoft SQL Server

visual studio.net 2005 license question?

by: =?Utf-8?B?V2VuZHkgRWxpemFiZXRo?= | last post by:

I am working at a company where I am the only .net programmer. I want to be able to test sql server 2000 t-sql commands using Visual Studio.net 2005 professional version. I have read articles from...

.NET Framework

Re: f2py Error - module crashes after several iterations...

by: John [H2O] | last post by:

Python

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

After Sql 2005 Install, Sql 2000 Still There

Similar topics