United States

Change

All Microsoft Sites

Microsoft Support

Article ID: 300538 - Last Review: September 4, 2006 - Revision: 2.1

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

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