By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,502 Members | 1,159 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,502 IT Pros & Developers. It's quick & easy.

Which SP3a for SQL 2000 Personal Edition?

P: n/a
Hi folks,

I need to know which EXE's of SP3 to install with SQL Server 2000 Personal
Edition. From the Microsoft website:
http://www.microsoft.com/downloads/d...displaylang=en

....it has these 3 files:

Database Components
Downloadable file name: SQL2KSP3.exe (56453 KB)
Updates for the database components of SQL Server 2000 include: Data
engine. Database
client utilities, such as SQL Server Enterprise Manager and osql for
SQL Server 2000. Database
client connectivity components, such as the OLE DB Provider for SQL
Server, the SQL Server
Open Database Connectivity (ODBC) driver, and the client
Net-Libraries.

Analysis Services Components
Downloadable file name: SQL2KASP3.exe (44617 KB)
Updates for the Analysis Services components of SQL Server 2000
include: Analysis Services
engine. Analysis Services client components, such as Analysis
Manager and the OLE DB Provider
for Analysis Services. Database client connectivity components, such
as the OLE DB Provider for
SQL Server, the SQL Server ODBC driver, and the client
Net-Libraries.

SQL Server 2000 Desktop Engine(MSDE)
Downloadable file name: SQL2kdesksp3.exe (70815 KB)
SP3a updates for MSDE include updates and new installations for the
database components of instances
of the SQL Server 2000 Desktop Engine, including: The Desktop data
engine. Database client connectivity
components, such as the OLE DB Provider for SQL Server, the SQL
Server ODBC driver, and the client
Net-Libraries. SQL2kdesksp3.exe includes all of the files that are
required to install a new instance of
Desktop Engine (.msi files), to upgrade all existing instances of
Desktop Engine (.msp files), as well as
to consume merge modules (.msm files) into applications. You can
install the three parts of SP3a
described above individually. However, if you want to upgrade both
your database components and
Analysis Services components, you must apply both the SP3a database
components and the SP3a
Analysis Services components.

Which one(s) do I need to install for Personal Edition? This is important,
because we need to build an install CD for the office, and space is limited
(due to other files).

Can anyone help?

Greg
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
The first one (SQL2KSP3.exe). The second one is for Analysis Services, and
the third is for MSDE.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

"gregs" <jo**@smith.com> wrote in message
news:Sf2fc.111458$oR5.66769@pd7tw3no...
Hi folks,

I need to know which EXE's of SP3 to install with SQL Server 2000 Personal
Edition. From the Microsoft website:

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.