SUMMARY
Following is part 2 of a list of fixes and various other improvements that have been made in Service Pack 1 (SP1) for Microsoft SQL Server 2000. For more information, contact your primary support provider. For additional listings, click the article numbers below to view the articles in the Microsoft Knowledge Base:
290212 INF: List of Bugs Fixed in SQL Server 2000 Service Pack 1 (1 of 2)
300634 INFO: List of Bugs Fixed in MDAC 2.6 Service Pack 1
To determine which Service Pack level your SQL Server server is currently running, run the following statement from the SQL Server Query Analyzer window:
SELECT @@version
The result of this query is:
8.00.194 if SQL Server 2000 with no service pack applied
8.00.384 if SQL Server 2000 Service Pack 1
Note that the workarounds described in these articles are provided for information only. You do not need to implement these workarounds if you have the updated software.
For more information about each corrected problem in Service Pack 1 for Microsoft SQL Server 2000 (build 8.00.384), either click the link or use the Q
xxxxxx number to query for the article in the Microsoft Knowledge Base.
To view the Service Pack 1 Readme.txt file that accompanies the Service Pack 1, see the following article in the Microsoft Knowledge Base:
300516 INF: Readme.txt File for SQL Server 2000 Service Pack 1
For additional information on obtaining SQL Server 2000 Service Pack 1, click the article number below
to view the article in the Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
MORE INFORMATION
SQL Server 2000 Analysis Services
Bug ID:2109
291265 BUG: Error Occurs when you Exit Internet Explorer or Excel When You Use a Pivot Table Control with a Visual Basic User Defined Function
Bug ID:5074
294703 FIX: Incorrect Data in Local Cube Using Custom Rollup with Parent Child Dimension and UNARY Operator
Bug ID:10693
293516 FIX: Processing of Remote Partition Fails When Dimension and Fact Table Are in Different Data Sources
Bug ID:10748
294371 BUG: Cubes and Dimensions Not Visible After Upgrading From OLAP Services 7.0 to Analysis Services 8.0
Bug ID:10768
293528 FIX: Drill-Through Fails if Dimension Table Has an Alias in the Cube
Bug ID:10884
294535 FIX: Real-Time Cubes Fail to Process with a Measure Defined as Distinct Count
Bug ID:11012
294734 FIX: Invalid Data Displays after Refreshing the Definition of a Cube That Contains Virtual Dimensions
Bug ID:11047
294746 FIX: Error Occurs When Changes are Made to Dimension Security for Very Large Dimensions
Bug ID:11049
294968 FIX: Error Processing Partitions in Parallel Through DTS May Cause Processing to Fail
Bug ID:11122
281117 BUG: Timeout Error Occurs with Large Dimensions in Dimension Editor or Wizard
Bug ID:11133
295634 FIX: Server Fails with Query to Cube with Multiple Partitions and Distinct Count Measure
Bug ID:11175
295737 FIX: Analysis Manager Reports Error: Cannot Create Temp Directory Due to Disk Space Problems
Bug ID:11209
296064 FIX: Analysis Services Cubes Restored From Archive May Show #ERR When Browsed
Bug ID:11226
296380 FIX: IS_DRILLTHROUGH_ENABLED in MDSCHEMA_CUBES Resultset Invalid for Copied Objects
Bug ID:11238
295985 FIX: Creating a Local Cube from a Linked Cube May Return Error
Bug ID:11250
296419 FIX: Cannot Set Parent for Calculated Member to Member of Parent-Child Dimension
Bug ID:11267
296420 FIX: Incremental Update of Cube Results in Empty Cube if Partition Was Previously Empty
Bug ID:11277
298595 FIX: Order and Format of Dimension Members Not Maintained After Processing
Bug ID:11302
278239 FIX: Extreme Memory Usage When Adding Many Security Roles
Bug ID:11310
297179 FIX: OLAP Service Fails to Start After Changing Sort Order to Binary on Japanese Windows
Bug ID:11322
294276 FIX: "Subscript Out of Range" Error Message in Usage Analysis Report
Bug ID:11327
296905 FIX: Data Mining Provider Stops Responding When Using Row Navigation through OLE DB API
Bug ID:11357
297205 FIX: A Remote Cut and Paste of a SQL Server 7.0 Cube or Dimension In Analysis Manager Causes an Error
Bug ID:11398
296901 FIX: Cube Editor Stops Responding on Save After Adding Private Dimension
Bug ID:11418
296915 FIX: Access Violation When Processing a Database That Was Restored Over Existing Database
Bug ID:11422
279490 BUG: Analysis Services 2000 Does Not Support Security Account Delegation
Bug ID:11427
297248 FIX: Server Shutdown When Processing a Cube with Private, Virtual, and Shared Dimensions
Bug ID:11428
296929 FIX: Creation of Ad Hoc Data Mining Models Fails with Mining Execution Location=3
Bug ID:11472
294664 FIX: Timeout Error While Browsing Data from Analysis Manager
Bug ID:11508
297889 PRB: Unable to Count Fact Table Rows When Creating a Cube
Bug ID:11536
296774 FIX: DTS Logs Processing Messages Even When Package Logging Is Turned Off
Bug ID:11549
296652 FIX: Dimension Editor Displays Error Message While Setting Default Member
Bug ID:11551
291364 FIX: Query Performance Slower When Client Locale Differs from Server Locale
Bug ID:11580
291563 FIX: Analysis Server HTTPS Connections Slower Than HTTP and TCP/IP Connections
Bug ID:11603
293616 INF: How to Migrate Repository from Meta Data Format to SQL Server Database Format
Bug ID:11617
289804 BUG: Dimension Wizard Generates Unusable Custom Rollup Formula with Private Parent-Child Dimension
Bug ID:11938
296378 FIX: Query Using NON EMPTY Clause Fails for Measures with a Large Cellset
Bug ID:11944
298600 FIX: Partition Stops Inheriting FromClause Property from Parent Cube
Bug ID:11954
293463 FIX: ASP Error 0115 Occurs When Connecting Through HTTP to Analysis Server on Windows NT 4.0
Bug ID:11960
298700 FIX: Syntax Error Occurs When You Use EQUAL_AREAS or THRESHOLDS Keyword for DISCRETIZED Method
Bug ID:11998
293195 FIX: Use of the Colon Operator to Define a Range of Members May Cause Incorrect Results in MDX Query
Bug ID:12004
295446 FIX: MSOLAP 8.0 Provider Returns Invalid Property Values for Non-Leaf Members
Bug ID:12024
296381 FIX: Creating a Local Cube with a Large Number of Measures May Cause Error on the Client
Bug ID:12053
290562 BUG: HTTP Connection Resets Session ID of an ASP Session Object
Bug ID:12056
291374 FIX: Creation of Local Cube with More Than 202 Measures May Fail
Bug ID:12096
293776 FIX: Cube Remains in Repository Database After Restore of Archived Database Without Cube
Bug ID:12147
295706 FIX: Virtual Cube Returns Empty Cells if Custom Rule Is Applied
Bug ID:12157
293318 FIX: Analysis Services DTS Task Gets Timeout Error During Incremental Update
Bug ID:12254
296267 FIX: Analysis Services Cubes Using Unisys DMS II Database Report ODBC Error
Bug ID:11266, 11168
295537 FIX: Unable to Save Changes to Analysis Services Named Sets
Bug ID:11281, 11210, 12010
293641 FIX: Error Occurs When You Process Cube or Dimension Through ASP
Bug ID:11361, 12152, 12162
294285 BUG: Processing All Dimensions May Fail with Very Large Dimensions
Bug ID:11406, 12157
293318 FIX: Analysis Services DTS Task Gets Timeout Error During Incremental Update
Bug ID:11551, 11553
291364 FIX: Query Performance Slower When Client Locale Differs from Server Locale
Bug ID:11580, 11471
291563 FIX: Analysis Server HTTPS Connections Slower Than HTTP and TCP/IP Connections
Bug ID:11928, 11998
293195 FIX: Use of the Colon Operator to Define a Range of Members May Cause Incorrect Results in MDX Query
Bug ID:12092, 12178
294993 FIX: Combination of Order and CrossJoin Functions in MDX Causes Error
Bug ID:12136, 11457
296639 FIX: Analysis Services Fails When All Shared Dimensions Are Processed