SQL Server 2000 articles, fixes and updates - November 2013

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2000 that have been released in November 2013. The list is daily updated.

• 302892 FIX: Specifying More Than One Operator E-mail Address May Terminate SQL Server Agent with Dr. Watson Q302892 KB302892 November 3, 2013
• 940020 Error message when you try to connect to an instance of SQL Server 2000 Analysis Services by using Decision Support Objects: "Data source name not found or no default data source" Q940020 KB940020 November 2, 2013
• 939567 You obtain an incorrect result or receive a "Formula error - cannot find dimension member" error message when you run a MDX query in SQL Server 2000 Analysis Services Q939567 KB939567 November 2, 2013
• 932697 FIX: A calculated member that uses the DistinctCount function always returns 0 when you query a virtual cube that contains the calculated member after you install SQL Server 2000 Analysis Services Service Pack 4 Q932697 KB932697 November 2, 2013
• 926940 FIX: SQL Server 2000 Service Pack 4 stops responding after you close a SQL Server connection on a computer that is running Windows Server 2003 Service Pack 1 Q926940 KB926940 November 2, 2013
• 925745 FIX: The members of a role that uses dynamic security cannot access the SQL Server 2000 Analysis Services database when you run a query against a cube Q925745 KB925745 November 2, 2013
• 925000 FIX: An access violation may occur in SQL Server 2000 Analysis Services when you try to use a 2007 Office system program to open an offline local cube Q925000 KB925000 November 2, 2013
• 920121 FIX: Error message when you add a calculated member to a cube in SQL Server 2000 Analysis Services Service Pack 4: "Unable to update the calculated member" Q920121 KB920121 November 2, 2013
• 919159 Error message when you use the Analysis Services Parallel Process Utility to process a partition of SQL Server 2000 Analysis Services: "Run-time error '380': Invalid property value" Q919159 KB919159 November 2, 2013
• 916097 FIX: You may not be able to use Analysis Manager to change server properties for an instance of SQL Server 2000 Analysis Services that is running on an IA-64 server computer after you install Windows Server 2003 SP1 on a client computer Q916097 KB916097 November 2, 2013
• 914191 BUG: The vacuuming process stops running when you configure the generator to run on a different computer in SQL Server 2000 Notification Services Q914191 KB914191 November 2, 2013
• 913049 FIX: The result set contains data for the whole relational source when you execute a query to retrieve a drillthrough result set in SQL Server 2000 Analysis Services Q913049 KB913049 November 2, 2013
• 912468 FIX: The connection that processes the cube stops responding, and the cube is locked in SQL Server 2000 Analysis Services Q912468 KB912468 November 2, 2013
• 911023 FIX: In SQL Server 2000 Analysis Services, a memory leak may occur in the handle thread when you run an MDX query that uses formulas or recursions Q911023 KB911023 November 2, 2013
• 910480 FIX: Real-time updates that are made on Relational Online Analytical Process partitions may not be reflected in the query results when you use SQL Server 2000 Analysis Services Q910480 KB910480 November 2, 2013
• 910020 FIX: Error message when you create an instance of SQL Server 2000 Notification Services together with a large event field: "Invalid operator for data type" Q910020 KB910020 November 2, 2013
• 903030 FIX: A Decision Support Objects (DSO) connection attempt fails after you install SQL Server 2000 Analysis Services Service Pack 4 Q903030 KB903030 November 2, 2013
• 903004 You may experience an access violation or data corruption in Analysis Services when you use DTS to merge partitions when lazy processing is occurring Q903004 KB903004 November 2, 2013
• 899806 FIX: The MSSQLServerOLAPService service restarts unexpectedly when you use the ALTER CUBE statement in SQL Server 2000 Analysis Services Q899806 KB899806 November 2, 2013
• 899025 FIX: The SQL Server 2000 Analysis Services process may stop accepting connections and may appear to stop responding when you stop a SQL Server transaction after that transaction requests a lock Q899025 KB899025 November 2, 2013
• 899024 FIX: You may not be able to capture user dump files in SQL Server 2000 Analysis Services Q899024 KB899024 November 2, 2013
• 897350 FIX: The naming convention that the Partition Aggregation utility and the Partition Manager utility use could allow duplicate aggregations for partitions Q897350 KB897350 November 2, 2013
• 897123 FIX: A hidden report table may unexpectedly appear in an Office Excel worksheet when the table was exported from SQL Server 2000 Reporting Services Q897123 KB897123 November 2, 2013
• 896864 You experience a decrease in query performance after you perform an incremental process on a virtual dimension in SQL Server 2000 Analysis Services Q896864 KB896864 November 2, 2013
• 894687 FIX: The Spanish versions of SQL Server 2000 Analysis Services hotfix packages do not install correctly Q894687 KB894687 November 2, 2013
• 891575 FIX: The MDX query is unsuccessful and you receive an error message if you query a ROLAP-based dimension in SQL Server 2000 Analysis Services Q891575 KB891575 November 2, 2013
• 887596 FIX: Memory usage increases when you process cubes in Analysis Services Q887596 KB887596 November 2, 2013
• 886835 BUG: You receive an "Unable to update role in cube" error message, and Analysis Manager or a DSO application indicates incorrect permissions in SQL Server 2000 Analysis Services Q886835 KB886835 November 2, 2013
• 885444 FIX: PDF files that are exported by SQL Server 2000 Reporting Services can only be opened by using Adobe Acrobat Reader Q885444 KB885444 November 2, 2013
• 884844 FIX: You may receive an error message when you use the GetSchemaDataSet function to obtain cube metadata in Analysis Services Q884844 KB884844 November 2, 2013
• 884395 You may notice a “#ERR” in the result set when you run an MDX query on a local ROLAP cube that contains a parent-child dimension in SQL Server 2000 Analysis Services Q884395 KB884395 November 2, 2013
• 883675 FIX: Invalid values appear in a chart if you change the default color for the value series in SQL Server 2000 Reporting Services Service Pack 1 Q883675 KB883675 November 2, 2013
• 883501 FIX: You receive a "Width of Excel cell in the Excel sheet exceeded the maximum limit of 1726.5 points" error message when you export a Reporting Services report to Excel Q883501 KB883501 November 2, 2013
• 883485 FIX: Incorrect Multidimensional Expressions (MDX) expressions are generated in the Custom Security Dimension dialog box if you choose the ragged dimension members that has hidden parent members Q883485 KB883485 November 2, 2013
• 875518 FIX: The width of a list that contains an embedded matrix grows unexpectedly when you export a report to PDF format Q875518 KB875518 November 2, 2013
• 873440 FIX: You may receive an error message when an invalid user tries to browse an Analysis Services cube that implements dynamic dimension security by defining a custom cube role Q873440 KB873440 November 2, 2013
• 872977 Actions in an SQL Server 2000 Analysis Services cube may return incorrect results or the actions are not accessible when you try to access the actions by using a client application Q872977 KB872977 November 2, 2013
• 843369 An addition to the SQL Server 2000 Reporting Services SP1 Readme.htm file Q843369 KB843369 November 2, 2013
• 843262 FIX: You may notice that the query performance on an Analysis Services cube degrades temporarily after an incremental update processes the virtual dimensions Q843262 KB843262 November 2, 2013
• 843245 New Microsoft Visual Basic for Applications (VBA) functions are added to SQL Server 2000 Analysis Services Q843245 KB843245 November 2, 2013
• 842859 FIX: Drillthrough operations on a cube fail if the dimension table has been assigned an alias Q842859 KB842859 November 2, 2013
• 842857 The Readme.txt file for SQL Server 2000 Reporting Services Service Pack 1 Q842857 KB842857 November 2, 2013
• 841856 FIX: A memory leak occurs when you run queries in the same connection in Analysis Services Q841856 KB841856 November 2, 2013
• 837390 FIX: An exception occurs when you run a SQL Server CE RDA application that tries to connect to the SQL Server CE Server Agent by using an HTTPS connection Q837390 KB837390 November 2, 2013
• 834777 FIX: Some cubes are not processed by the process database operation Q834777 KB834777 November 2, 2013
• 833634 SAPWD is incorrectly translated as SAPWP in an error message in the Spanish version of the SQL Server 2000 Desktop Engine (MSDE) SP3 Setup program Q833634 KB833634 November 2, 2013
• 831370 The PivotTable service setup fails and you receive the error message "Target language is not supported for upgrade." Q831370 KB831370 November 2, 2013
• 831352 PRB: Calculated Member Returns Incorrect Value When You Divide a Currency Data Type Measure with a Real Data Type Measure Q831352 KB831352 November 2, 2013
• 831044 FIX: The OpenSchema Method Returns Null for the Custom Member Property of a Parent-Child Dimension Level Q831044 KB831044 November 2, 2013
• 827967 You receive an "Unable to parse the subcube MDX expression in the CREATE CELL FORMULA statement" error when you edit a calculated cell in SQL Server 2000 Analysis Services Q827967 KB827967 November 2, 2013
• 825713 Decimal data type values and Numeric data type values in OLAP cubes are rounded off Q825713 KB825713 November 2, 2013
• 824419 "Unable to process one or more commands" error message when you test a cube role in SQL Server 2000 Analysis Services Q824419 KB824419 November 2, 2013
• 824042 PRB: The SQL Server Desktop Engine Setup Program May Stop Responding When It Is Started from an External Application Q824042 KB824042 November 2, 2013
• 822718 Incorrect data may be written to the writeback table when you use the USE_WEIGHTED_ALLOCATION allocation method to update a cube in Analysis Services Q822718 KB822718 November 2, 2013
• 822339 INF: Enhancements to SQL Server 2000 Notification Services Service Packs Q822339 KB822339 November 2, 2013
• 822277 FIX: Analysis Services Service Quits During Processing and Does Not Restart Q822277 KB822277 November 2, 2013
• 822215 INF: The versions of Teradata that are supported by Analysis Services Q822215 KB822215 November 2, 2013
• 821463 FIX: Pending Writeback May Cause Results That Are Not Accurate Q821463 KB821463 November 2, 2013
• 819609 FIX: The XML for Analysis Services provider result set does not contain the hierarchy name Q819609 KB819609 November 2, 2013
• 819541 BUG: MDX Query Does Not Return Correct Results When Writeback Data Is Not Committed Q819541 KB819541 November 2, 2013
• 819100 MDAC Cliconfg.* files are not upgraded after you install SQL Server 2000 SP3a Q819100 KB819100 November 2, 2013
• 818765 FIX: Trace Flag -T8002 Treats Affinity Masks Like Process Affinities Q818765 KB818765 November 2, 2013
• 818764 FIX: Cannot Set SQL Server Instance Specific Network Affinity Q818764 KB818764 November 2, 2013
• 818389 BUG: Unexpected Behavior Occurs When You Perform a Drill Down of a Parent-Child Dimension That Has a Ragged Hierarchy Q818389 KB818389 November 2, 2013
• 816652 FIX: XMLA Returns Malformed Response if Query Result Contains #ERR in Cells Q816652 KB816652 November 2, 2013
• 814851 FIX: SQL Server CE Application Fails on Pocket PC 2002 Emulator on Pentium IV Processor Q814851 KB814851 November 2, 2013
• 814514 Overview of Version 3.0 of the SQL Server 2000 Security Tools Q814514 KB814514 November 2, 2013
• 814461 INF: SQL Server 2000 SQL Check Utility Q814461 KB814461 November 2, 2013
• 813645 FIX: Improved CPU Usage for Database Logging When Transaction Log Stalls Occur Q813645 KB813645 November 2, 2013
• 811903 BUG: Stored Procedures Do Not Accurately Report Failed Notifications Q811903 KB811903 November 2, 2013
• 811478 FIX: Restoring a SQL Server 7.0 database backup in SQL Server 2000 Service Pack 2 (SP2) may cause an assertion error in the Xdes.cpp file Q811478 KB811478 November 2, 2013
• 810440 FIX: MDX Queries Return "#Err" as the Result Set When You Enable "Visual Totals" on Private Parent-Child Dimension Q810440 KB810440 November 2, 2013
• 810343 PRB: SQL Server 2000 Service Pack 3 Setup Fails If Windows Security Policy Is Set Q810343 KB810343 November 2, 2013
• 810010 FIX: The fn_get_sql System Table Function May Cause Various Handled Access Violations Q810010 KB810010 November 2, 2013
• 329479 FIX: Cannot Set Description for Dimensions and Measures by Using the CREATE GLOBAL CUBE Statement Q329479 KB329479 November 2, 2013
• 328721 PRB: Analysis Services Properties are Empty or Set to Zero Q328721 KB328721 November 2, 2013
• 328573 PRB: User in Two Roles May Cause Query Execution Failure Q328573 KB328573 November 2, 2013
• 327239 You may receive an error message when you try to perform a drillthrough query or retrieve data from a writeback table Q327239 KB327239 November 2, 2013
• 326559 FIX: SSCE Replication Client Agent Stops Responding with Merge of Large Text or Image Q326559 KB326559 November 2, 2013
• 325811 CERowset Sample That Executes a Query and Opens a Rowset on a Session Q325811 KB325811 November 2, 2013
• 325788 BUG: Documentation error in the "Reinitializing a Subscription" topic in SQL Server CE 1.1 Books Online Q325788 KB325788 November 2, 2013
• 325687 Embedded SQL for C Application Fails When It Experiences a Lock Timeout Error Q325687 KB325687 November 2, 2013
• 325289 FIX: New functionality for incremental update of changing dimensions Q325289 KB325289 November 2, 2013
• 324859 FIX: An Analysis Services Virtual Cube That Is Based on a Real-Time ROLAP Cube Does Not Receive Updates from the Source Q324859 KB324859 November 2, 2013
• 322677 BUG: You Receive an Error Message If the Member Caption Is Different from the Member Name Q322677 KB322677 November 2, 2013
• 322596 INF: Creating Large-Scale, Highly Available OLAP Sites (White Paper) Q322596 KB322596 November 2, 2013
• 322325 INF: Performance Study of Microsoft Data Mining Algorithms (White Paper) Q322325 KB322325 November 2, 2013
• 322320 INF: SQL Server CE Relay Q322320 KB322320 November 2, 2013
• 322226 INF: XML for Analysis Specification (White Paper) Q322226 KB322226 November 2, 2013
• 322074 INF: International Considerations in Applications Developed for SQL Server 2000 Windows CE Edition Q322074 KB322074 November 2, 2013
• 320730 FIX: You may receive an "Error Connecting OLAP Catalog: Database '<databaseName>' does not exist." error message when you try to connect to a cube by using a role that was created with DSO through an ASP page in SQL Server 2000 Analysis... Q320730 KB320730 November 2, 2013
• 320719 FIX: Analysis Services Client Application Memory Usage Grows Each Time You Run a Query Q320719 KB320719 November 2, 2013
• 320061 PRB: Error Message: "Evaluation copy has expired" May Occur After You Upgrade to Release Version of SQL Server CE Q320061 KB320061 November 2, 2013
• 319641 FILE: New Syntax Available to Create Local Cubes Q319641 KB319641 November 2, 2013
• 319637 PRB: Incorrect Values Display When You Use a Count Function to View a Cube That Has a Virtual Dimension and a Measure Q319637 KB319637 November 2, 2013
• 319636 BUG: Date Formats Change to DBTimeStamp After Server Processes Cube Q319636 KB319636 November 2, 2013
• 319634 BUG: User Cannot Create or Process an OLAP Database Even if the User is a Member of the OLAP Administrators Group Q319634 KB319634 November 2, 2013
• 319601 BUG: The second cluster node is not listed as a possible owner in Cluster Administrator Q319601 KB319601 November 2, 2013
• 319054 PRB: SELECT on a VIEW Generates an Access Violation When an 'IN' or 'OR' Clause Contains More Than 19 Values Q319054 KB319054 November 2, 2013
• 318898 PRB: The Merge Agent Stops Responding and You Receive the Error "The Schema Script 'File Location Pointed to a DRI Script File' Could Not Be Propagated to the Subscriber" Q318898 KB318898 November 2, 2013
• 318596 FIX: Analysis Services HTTP Connections Return "Access Denied" Error Messages Q318596 KB318596 November 2, 2013
• 317851 PRB: SQL Server CE x86 Emulation Files Do Not Work on Pocket PC 2002 Emulator Q317851 KB317851 November 2, 2013
• 317710 FIX: CREATE INDEX Statement with Parallel Plan May Stop Responding If Disk Space Is Almost Full Q317710 KB317710 November 2, 2013
• 317620 INF: You Are Prompted for File Location During MSDE 2.0 SP2 Setup Q317620 KB317620 November 2, 2013
• 317562 FIX: The calculated member that uses the ValidMeasure function may return an incorrect value in a virtual cube Q317562 KB317562 November 2, 2013
• 317341 Error occurs on RDA.LocalConnectionString when you use a large string Q317341 KB317341 November 2, 2013
• 317265 FIX: Real-Time Cube Unable to Re-Establish SQL Server Connection After Network Errors Occur Q317265 KB317265 November 2, 2013
• 317223 FIX: Performance Slows If You Process More Than Two Partitions In Parallel Q317223 KB317223 November 2, 2013
• 316497 INF: List of Bugs Fixed by SQL Server 2000 Windows CE Edition 1.1 Service Packs Q316497 KB316497 November 2, 2013
• 316335 FIX: Analysis Service Uses Large Amounts of Client Memory for Queries Q316335 KB316335 November 2, 2013
• 316285 FIX: Unexpected Internal Error Occurs When You Query a Virtual Cube with Calculated Measures Q316285 KB316285 November 2, 2013
• 315970 FIX: #ERR Occurs When You Browse a Cube That Is Write-Enabled and has a Virtual Dimension and an Oracle Data Source Q315970 KB315970 November 2, 2013
• 315889 FIX: Insertion of NULL Values into NTEXT Columns May Cause Application Instability Q315889 KB315889 November 2, 2013
• 315463 How to implement a SQL Server 2000 Desktop Engine callback function and example Q315463 KB315463 November 2, 2013
• 315109 FIX: Join of Multiple Tables May Fail with E_OUTOFMEMORY Error Message Q315109 KB315109 November 2, 2013
• 314309 INF: SQL Server 2000 Service Pack 1 and Service Pack 2 Fixlist for SQL Mail Q314309 KB314309 November 2, 2013
• 313269 FIX: When you run an MDX query on a write-enabled cube, the query returns #Err, or the query fails and you receive an "Unable to open cellset..." error message in SQL Server 2000 Analysis Services Q313269 KB313269 November 2, 2013
• 313153 Windows NT account lockout with SQL Server CE Replication and invalid password Q313153 KB313153 November 2, 2013
• 311528 BUG: Infinite Recursion Error with Parent-Child Dimension and Custom Member Q311528 KB311528 November 2, 2013
• 310468 FIX: Error 3314 May Occur with Simultaneous DDL and DML Statements on SQL Server 2000 Service Pack 1 Q310468 KB310468 November 2, 2013
• 309400 FIX: Merge Replication Non-Convergence Fixes in SQL Server 2000 SP2 Q309400 KB309400 November 2, 2013
• 308878 FIX: sp_mergemetadataretentioncleanup Does Not Clean Generations with ArtNick=0 Q308878 KB308878 November 2, 2013
• 308853 BUG: SP1 Regression: Uninstalling SQL Server 2000 Does Not Remove the MSSQLServerADHelper Service Q308853 KB308853 November 2, 2013
• 307932 FIX: SQL Mail Operations Are Not Thread Safe When You Use Them in Conjunction with the xp_stopmail Stored Procedure Q307932 KB307932 November 2, 2013
• 307530 FIX: SQL Server CE OLE DB Provider Specific Properties Give Compilation Error Q307530 KB307530 November 2, 2013
• 305349 FIX: SSCE:Temp File Directory Property Allows You to Change the Temp Database Location for SQL Server CE Q305349 KB305349 November 2, 2013
• 304215 How to create multiple distinct count measures in a single cube Q304215 KB304215 November 2, 2013
• 304060 PRB: SQL Server CE Replication Error Message: 28557 : "The database is in an unusable state. " Q304060 KB304060 November 2, 2013
• 304058 HOWTO: Perform Replication by Using SSCERelay and ActiveSync Q304058 KB304058 November 2, 2013
• 303680 SQL Server 2000 MSDE Service Pack 1 Setup on Windows 98 computer fails with error message Q303680 KB303680 November 2, 2013
• 302349 HOWTO: Perform RDA Pull by Using SSCERelay and ActiveSync Q302349 KB302349 November 2, 2013
• 300478 BUG: Print Jobs from Query Analyzer Fail to Complete Spooling Q300478 KB300478 November 2, 2013
• 295748 INFO: SQL Server CE Bits for CEPC Installed Only if Platform Builder 3.0 is Installed Q295748 KB295748 November 2, 2013
• 292724 PRB: Uninstalling SQL Server CE Version 1.1 Does Not Cause Platform Builder 3.0 to Remove Existing References Q292724 KB292724 November 2, 2013
• 285854 PRB: Application Error Occurs When You Run Two Instances of Replication or RDA Application on HPC Pro Devices Q285854 KB285854 November 2, 2013
• 283844 FIX: DATEADD does not accept scientific notation for the NUMBER argument Q283844 KB283844 November 2, 2013
• 282017 PRB: SQL Server 2000 Help File Contains Confusing Information About the Desktop Engine Setup Q282017 KB282017 November 2, 2013
• 281213 PRB: SQL Server CE Setup on Windows 2000 Error Message: The Installer Was Interrupted Q281213 KB281213 November 2, 2013
• 280514 How To Use AppendChunk and GetChunk with NText Columns in a SQL Server CE Database Q280514 KB280514 November 2, 2013
• 280082 FIX: SQL Server CE Queries with WHERE and ORDER BY Clauses May Run Slow Q280082 KB280082 November 2, 2013
• 275305 FIX: Directory Name \MSDE2000\RESOURCES Is More Than Eight Characters, Resulting in Non-ISO CD Q275305 KB275305 November 2, 2013
• 274255 PRB: ADOXCE Error Message: "..Specified type was invalid" for SQL Server CE Table Q274255 KB274255 November 2, 2013
• 271592 INFO: Cannot Create a SQL Server CE Database on Connection.Execute Q271592 KB271592 November 2, 2013
• 270896 INFO: SQL Server CE Query Analyzer Does Not Display Descriptive Data Type Q270896 KB270896 November 2, 2013
• 917829 How to set the memory conservation threshold for SQL Server 2000 Analysis Services 32-bit edition on a 64-bit version of Windows Q917829 KB917829 November 1, 2013
• 830629 You Cannot Install MSDE 2000 SP3 on a Windows 2000 Terminal Server in Application Server Mode Q830629 KB830629 November 1, 2013
• 829925 Additions to the SQL Server 2000 Desktop Engine (MSDE) Release A ReadmeMSDE2000A.htm File Q829925 KB829925 November 1, 2013
• 271931 INFO: Using Multiple Recordsets for Performance with SQL Server CE Database Q271931 KB271931 November 1, 2013