quote:
Data components is the normal service pack, Sql2ksp3.exe that you already installed.Analysis Services is a special component of SQLServer, that you could have installed while installing SQLServer. If you do not know it, you probably won't need it.
It is has its own service pack, Sql2kasp3.exe and you can install it after the data components service pack. I am not sure if it is necessary, just never got the idea to do it first.
Sorry that it seems I'm belaboring the point, but as I look at the MS technet site for downloads for SQL Server 2000 http://www.microsoft.com/sql/downloads/2000/sp3.asp, and scroll down to about the middle of the page, it says :
"This service pack includes the following files:
Sql2ksp3.exe. Updates for database components.
Sql2kasp3.exe. Updates for Analysis Services components.
Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine (MSDE 2000).
Note: The service pack files for SP3a have the same names as the files for SP3."
I installed the last one only as it was the only one on my Develop Edition CD.
Am I okay with that, or do I need to get the Sql2ksp3.exe installed also?