Microsoft KB Archive/300538

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

Article ID: 300538

Article Last Modified on 9/4/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 1

-



This article was previously published under Q300538



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 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 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: &quot;Subscript Out of Range&quot; 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

Additional query words: kbsqlservsp1fixlist FixList

Keywords: kbinfo KB300538

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.