INF: List of Bugs Fixed in SQL Server 2000 Service Pack 1 (2 of 2)

Article ID: 300538 - View products that this article applies to.
This article was previously published under Q300538
Expand all | Collapse all

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
(http://support.microsoft.com/kb/290212/EN-US/ )
INF: List of Bugs Fixed in SQL Server 2000 Service Pack 1 (1 of 2)
300634
(http://support.microsoft.com/kb/300634/EN-US/ )
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 Qxxxxxx 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
(http://support.microsoft.com/kb/300516/EN-US/ )
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
(http://support.microsoft.com/kb/290211/EN-US/ )
INF: How to Obtain the Latest SQL Server 2000 Service Pack

MORE INFORMATION

SQL Server 2000 Analysis Services

Bug ID:2109
291265
(http://support.microsoft.com/kb/291265/EN-US/ )
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
(http://support.microsoft.com/kb/294703/EN-US/ )
FIX: Incorrect Data in Local Cube Using Custom Rollup with Parent Child Dimension and UNARY Operator
Bug ID:10693
293516
(http://support.microsoft.com/kb/293516/EN-US/ )
FIX: Processing of Remote Partition Fails When Dimension and Fact Table Are in Different Data Sources
Bug ID:10748
294371
(http://support.microsoft.com/kb/294371/EN-US/ )
BUG: Cubes and Dimensions Not Visible After Upgrading From OLAP Services 7.0 to Analysis Services 8.0
Bug ID:10768
293528
(http://support.microsoft.com/kb/293528/EN-US/ )
FIX: Drill-Through Fails if Dimension Table Has an Alias in the Cube
Bug ID:10884
294535
(http://support.microsoft.com/kb/294535/EN-US/ )
FIX: Real-Time Cubes Fail to Process with a Measure Defined as Distinct Count
Bug ID:11012
294734
(http://support.microsoft.com/kb/294734/EN-US/ )
FIX: Invalid Data Displays after Refreshing the Definition of a Cube That Contains Virtual Dimensions
Bug ID:11047
294746
(http://support.microsoft.com/kb/294746/EN-US/ )
FIX: Error Occurs When Changes are Made to Dimension Security for Very Large Dimensions
Bug ID:11049
294968
(http://support.microsoft.com/kb/294968/EN-US/ )
FIX: Error Processing Partitions in Parallel Through DTS May Cause Processing to Fail
Bug ID:11122
281117
(http://support.microsoft.com/kb/281117/EN-US/ )
BUG: Timeout Error Occurs with Large Dimensions in Dimension Editor or Wizard
Bug ID:11133
295634
(http://support.microsoft.com/kb/295634/EN-US/ )
FIX: Server Fails with Query to Cube with Multiple Partitions and Distinct Count Measure
Bug ID:11175
295737
(http://support.microsoft.com/kb/295737/EN-US/ )
FIX: Analysis Manager Reports Error: Cannot Create Temp Directory Due to Disk Space Problems
Bug ID:11209
296064
(http://support.microsoft.com/kb/296064/EN-US/ )
FIX: Analysis Services Cubes Restored From Archive May Show #ERR When Browsed
Bug ID:11226
296380
(http://support.microsoft.com/kb/296380/EN-US/ )
FIX: IS_DRILLTHROUGH_ENABLED in MDSCHEMA_CUBES Resultset Invalid for Copied Objects
Bug ID:11238
295985
(http://support.microsoft.com/kb/295985/EN-US/ )
FIX: Creating a Local Cube from a Linked Cube May Return Error
Bug ID:11250
296419
(http://support.microsoft.com/kb/296419/EN-US/ )
FIX: Cannot Set Parent for Calculated Member to Member of Parent-Child Dimension
Bug ID:11267
296420
(http://support.microsoft.com/kb/296420/EN-US/ )
FIX: Incremental Update of Cube Results in Empty Cube if Partition Was Previously Empty
Bug ID:11277
298595
(http://support.microsoft.com/kb/298595/EN-US/ )
FIX: Order and Format of Dimension Members Not Maintained After Processing
Bug ID:11302
278239
(http://support.microsoft.com/kb/278239/EN-US/ )
FIX: Extreme Memory Usage When Adding Many Security Roles
Bug ID:11310
297179
(http://support.microsoft.com/kb/297179/EN-US/ )
FIX: OLAP Service Fails to Start After Changing Sort Order to Binary on Japanese Windows
Bug ID:11322
294276
(http://support.microsoft.com/kb/294276/EN-US/ )
FIX: "Subscript Out of Range" Error Message in Usage Analysis Report
Bug ID:11327
296905
(http://support.microsoft.com/kb/296905/EN-US/ )
FIX: Data Mining Provider Stops Responding When Using Row Navigation through OLE DB API
Bug ID:11357
297205
(http://support.microsoft.com/kb/297205/EN-US/ )
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
(http://support.microsoft.com/kb/296901/EN-US/ )
FIX: Cube Editor Stops Responding on Save After Adding Private Dimension
Bug ID:11418
296915
(http://support.microsoft.com/kb/296915/EN-US/ )
FIX: Access Violation When Processing a Database That Was Restored Over Existing Database
Bug ID:11422
279490
(http://support.microsoft.com/kb/279490/EN-US/ )
BUG: Analysis Services 2000 Does Not Support Security Account Delegation
Bug ID:11427
297248
(http://support.microsoft.com/kb/297248/EN-US/ )
FIX: Server Shutdown When Processing a Cube with Private, Virtual, and Shared Dimensions
Bug ID:11428
296929
(http://support.microsoft.com/kb/296929/EN-US/ )
FIX: Creation of Ad Hoc Data Mining Models Fails with Mining Execution Location=3
Bug ID:11472
294664
(http://support.microsoft.com/kb/294664/EN-US/ )
FIX: Timeout Error While Browsing Data from Analysis Manager
Bug ID:11508
297889
(http://support.microsoft.com/kb/297889/EN-US/ )
PRB: Unable to Count Fact Table Rows When Creating a Cube
Bug ID:11536
296774
(http://support.microsoft.com/kb/296774/EN-US/ )
FIX: DTS Logs Processing Messages Even When Package Logging Is Turned Off
Bug ID:11549
296652
(http://support.microsoft.com/kb/296652/EN-US/ )
FIX: Dimension Editor Displays Error Message While Setting Default Member
Bug ID:11551
291364
(http://support.microsoft.com/kb/291364/EN-US/ )
FIX: Query Performance Slower When Client Locale Differs from Server Locale
Bug ID:11580
291563
(http://support.microsoft.com/kb/291563/EN-US/ )
FIX: Analysis Server HTTPS Connections Slower Than HTTP and TCP/IP Connections
Bug ID:11603
293616
(http://support.microsoft.com/kb/293616/EN-US/ )
INF: How to Migrate Repository from Meta Data Format to SQL Server Database Format
Bug ID:11617
289804
(http://support.microsoft.com/kb/289804/EN-US/ )
BUG: Dimension Wizard Generates Unusable Custom Rollup Formula with Private Parent-Child Dimension
Bug ID:11938
296378
(http://support.microsoft.com/kb/296378/EN-US/ )
FIX: Query Using NON EMPTY Clause Fails for Measures with a Large Cellset
Bug ID:11944
298600
(http://support.microsoft.com/kb/298600/EN-US/ )
FIX: Partition Stops Inheriting FromClause Property from Parent Cube
Bug ID:11954
293463
(http://support.microsoft.com/kb/293463/EN-US/ )
FIX: ASP Error 0115 Occurs When Connecting Through HTTP to Analysis Server on Windows NT 4.0
Bug ID:11960
298700
(http://support.microsoft.com/kb/298700/EN-US/ )
FIX: Syntax Error Occurs When You Use EQUAL_AREAS or THRESHOLDS Keyword for DISCRETIZED Method
Bug ID:11998
293195
(http://support.microsoft.com/kb/293195/EN-US/ )
FIX: Use of the Colon Operator to Define a Range of Members May Cause Incorrect Results in MDX Query
Bug ID:12004
295446
(http://support.microsoft.com/kb/295446/EN-US/ )
FIX: MSOLAP 8.0 Provider Returns Invalid Property Values for Non-Leaf Members
Bug ID:12024
296381
(http://support.microsoft.com/kb/296381/EN-US/ )
FIX: Creating a Local Cube with a Large Number of Measures May Cause Error on the Client
Bug ID:12053
290562
(http://support.microsoft.com/kb/290562/EN-US/ )
BUG: HTTP Connection Resets Session ID of an ASP Session Object
Bug ID:12056
291374
(http://support.microsoft.com/kb/291374/EN-US/ )
FIX: Creation of Local Cube with More Than 202 Measures May Fail
Bug ID:12096
293776
(http://support.microsoft.com/kb/293776/EN-US/ )
FIX: Cube Remains in Repository Database After Restore of Archived Database Without Cube
Bug ID:12147
295706
(http://support.microsoft.com/kb/295706/EN-US/ )
FIX: Virtual Cube Returns Empty Cells if Custom Rule Is Applied
Bug ID:12157
293318
(http://support.microsoft.com/kb/293318/EN-US/ )
FIX: Analysis Services DTS Task Gets Timeout Error During Incremental Update
Bug ID:12254
296267
(http://support.microsoft.com/kb/296267/EN-US/ )
FIX: Analysis Services Cubes Using Unisys DMS II Database Report ODBC Error
Bug ID:11266, 11168
295537
(http://support.microsoft.com/kb/295537/EN-US/ )
FIX: Unable to Save Changes to Analysis Services Named Sets
Bug ID:11281, 11210, 12010
293641
(http://support.microsoft.com/kb/293641/EN-US/ )
FIX: Error Occurs When You Process Cube or Dimension Through ASP
Bug ID:11361, 12152, 12162
294285
(http://support.microsoft.com/kb/294285/EN-US/ )
BUG: Processing All Dimensions May Fail with Very Large Dimensions
Bug ID:11406, 12157
293318
(http://support.microsoft.com/kb/293318/EN-US/ )
FIX: Analysis Services DTS Task Gets Timeout Error During Incremental Update
Bug ID:11551, 11553
291364
(http://support.microsoft.com/kb/291364/EN-US/ )
FIX: Query Performance Slower When Client Locale Differs from Server Locale
Bug ID:11580, 11471
291563
(http://support.microsoft.com/kb/291563/EN-US/ )
FIX: Analysis Server HTTPS Connections Slower Than HTTP and TCP/IP Connections
Bug ID:11928, 11998
293195
(http://support.microsoft.com/kb/293195/EN-US/ )
FIX: Use of the Colon Operator to Define a Range of Members May Cause Incorrect Results in MDX Query
Bug ID:12092, 12178
294993
(http://support.microsoft.com/kb/294993/EN-US/ )
FIX: Combination of Order and CrossJoin Functions in MDX Causes Error
Bug ID:12136, 11457
296639
(http://support.microsoft.com/kb/296639/EN-US/ )
FIX: Analysis Services Fails When All Shared Dimensions Are Processed

Properties

Article ID: 300538 - Last Review: September 4, 2006 - Revision: 2.1
APPLIES TO
  • Microsoft SQL Server 2000 Service Pack 1
Keywords: 
kbinfo KB300538
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top