Article ID: 816502
This article has been archived. It is offered "as is" and will no longer be updated.
This article discusses several items that currently are not documented in the SP3aReadme.htm file for SQL Server 2000 Service Pack 3a (SP3a).
The following information has changed since the publication of the SP3aReadme.htm file:
Optimizing Cell WritebackSQL Server 2000 Service Pack 3 (SP3) and SQL Server 2000 Service Pack 3a (SP3a) improve the performance of cell writeback in Analysis Services by taking advantage of the bulk insert feature in SQL Server 2000 when performing permanent cell writeback operations on non-leaf cells. For more information, visit the following Microsoft Web site:
Optimizing Cell Writeback in Microsoft SQL Server 2000 Analysis Services
Clarification to Section 3.10 - Installing on a Failover ClusterIn section 3.10, under the title "To install SP3a on an Analysis Services cluster", it will read as follows:
Additional Paragraph for Section 4.1 - Unattended InstallationsIn section 4.1, under the title "Unattended Installation Considerations", add the following paragraph:
When you use the -s switch with an .iss file to install SQL Server 2000 Analysis Services Service Pack 3 (SP3) in unattended mode, the Error reporting dialog box remains open.
For more information about this issue, and to obtain the fix, see the following article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/814252/ )FIX: "Error Reporting" Dialog Box Remains Open During Analysis Services 2000 Service Pack 3 Silent Installation
Must Enable File and Print Sharing for Successful MSDE InstallationMake sure that you have File and Print Sharing enabled before you try to install MSDE. If you do not have File and Print Sharing for Microsoft Networks enabled in the Network Connections property box, the installation process may continue until it is almost finished and then unexpectedly roll back. If this occurs, the MSDE installation is not successful.
For additional information about SQL Server 2000 Service Pack 3a, visit the following Microsoft Web sites:
SQL Server 2000 SP3a Readme.htm
(https://support.microsoft.com/kb/306908/EN-US/ )INF: List of Bugs Fixed by SQL Server 2000 Service Packs
(https://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
(https://support.microsoft.com/kb/819334/EN-US/ )INF: SQL Server 2000 Service Pack 3a Synopsis