This article has been archived. It is offered "as is" and will no longer be updated.
We distribute SQL Server 2000 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that are included with the previous SQL Server 2000 hotfix release.
When certain changes are made to the member properties in a dimension, the dimension properties must be rebuilt. Previously, this kind of change did not warn the Microsoft SQL Server 2000 Analysis Services database administrator (DBA) that a full rebuild of the dimension properties may be required. This Microsoft SQL Server 2000 hotfix package now warns the DBA when such changes are made to the member properties in a dimension.
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack
This hotfix requires Microsoft SQL Server 2000 Analysis Services Service Pack 3 (SP3). For additional information about how to obtain SQL Server 2000 Service Pack 3, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 Service Pack
This hotfix contains only those files that are required to correct the issues that this article lists. This hotfix may not contain of all the files that you must have to fully update a product to the latest build.
The English version of this hotfix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.