SQL Server 2000 articles, fixes and updates - November 2006

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 2006. The list is daily updated.

• 927932 Error message when you try to connect to a cube server in ProClarity Web Professional or in ProClarity Desktop Professional: "Unspecified error" Q927932 KB927932 November 30, 2006
• 241643 PRB: 8198 Error Message Returned from Job Owned by Windows NT Authenticated User Q241643 KB241643 November 27, 2006
• 814571 PRB: Migrate Repository Wizard Does Not Migrate the Repository After You Install SQL Server 2000 Analysis Services Service Pack 3 Q814571 KB814571 November 24, 2006
• 814399 INF: Encrypted Password Is Not Supported in Intialization File for Installing SQL Server 2000 Service Pack 3 (SP3) Q814399 KB814399 November 24, 2006
• 814373 Microsoft Visual FoxPro 7.0 with MSDE 2000 installed may be vulnerable to the Slammer worm Q814373 KB814373 November 24, 2006
• 814086 How to Install SQL Server 2000 Security Patch MS02-061 or SP3 with BizTalk Server Q814086 KB814086 November 24, 2006
• 294349 How To Use ADO and SQL Server to Select Multiple Records by Unique Field Q294349 KB294349 November 23, 2006
• 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 21, 2006
• 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 21, 2006
• 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 21, 2006
• 915111 An error or an access violation occurs when you try to restore an archive file for a SQL Server 2000 Analysis Services database Q915111 KB915111 November 21, 2006
• 915091 Warning message when you install MMC 3.0 and you are running SQL Server 2000 Analysis Services: "MMC has detected an error in a snap-in." Q915091 KB915091 November 21, 2006
• 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 21, 2006
• 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 21, 2006
• 912468 FIX: The connection that processes the cube stops responding, and the cube is locked in SQL Server 2000 Analysis Services Q912468 KB912468 November 21, 2006
• 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 21, 2006
• 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 21, 2006
• 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 21, 2006
• 905615 A new registry key in SQL Server 2000 Analysis Services controls server behavior when a pre-SQL Server 2000 Analysis Services SP3 client tries to access the server Q905615 KB905615 November 21, 2006
• 903005 HTTP clients stop responding after you make only three concurrent HTTP connections to stress test applications in SQL Server Analysis Services SP3 Q903005 KB903005 November 21, 2006
• 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 21, 2006
• 900716 FIX: Physical memory usage increases for multithreaded applications in SQL Server 2000 Analysis Services Q900716 KB900716 November 21, 2006
• 899806 FIX: The MSSQLServerOLAPService service restarts unexpectedly when you use the ALTER CUBE statement in SQL Server 2000 Analysis Services Q899806 KB899806 November 21, 2006
• 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 21, 2006
• 899024 FIX: You may not be able to capture user dump files in SQL Server 2000 Analysis Services Q899024 KB899024 November 21, 2006
• 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 21, 2006
• 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 21, 2006
• 896174 FIX: Error message when you modify the security of a custom dimension in SQL Server 2000 Analysis Services: "Dimension Security Syntax Error: Set name 48818.79 is not valid" Q896174 KB896174 November 21, 2006
• 894687 FIX: The Spanish versions of SQL Server 2000 Analysis Services hotfix packages do not install correctly Q894687 KB894687 November 21, 2006
• 893091 FIX: You receive a "Connection timed out or lost" error message or a "COMException" error message when you use ADOMD.NET to connect to a remote OLAP server in SQL Server 2000 Analysis Services Q893091 KB893091 November 21, 2006
• 892139 FIX: An out-of-memory condition occurs when you run a query against a cube that contains calculated cells in SQL Server 2000 Analysis Services Q892139 KB892139 November 21, 2006
• 891580 FIX: Analysis Manager or another third-party DSO application crashes when you try to use a cell action in SQL Server 2000 Analysis Services Q891580 KB891580 November 21, 2006
• 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 21, 2006
• 890665 FIX: The Analysis Services service may unexpectedly stop and then restart on a server that is hosting a remote partition of a cube and that is running SQL Server 2000 Q890665 KB890665 November 21, 2006
• 890664 FIX: Event ID 128 may be logged if the lazy aggregation process is suspended multiple times in SQL Server 2000 Analysis Services Q890664 KB890664 November 21, 2006
• 889524 FIX: You receive an "Unexpected error encountered while updating repository Overflow" error message when you try to restore an OLAP database in SQL Server 2000 Analysis Services Q889524 KB889524 November 21, 2006
• 888800 A list of the bugs that are fixed in SQL Server 2000 Analysis Services Service Pack 4 Q888800 KB888800 November 21, 2006
• 888526 How to set up application names in SQL Server 2000 Analysis Services Q888526 KB888526 November 21, 2006
• 888504 FIX: A process operation on a cube may stop responding if the cube contains a ROLAP partition that is enabled for real-time updates in Analysis Services Q888504 KB888504 November 21, 2006
• 888096 FIX: You receive a "Cannot open Clipboard" error message in SQL Server 2000 Analysis Services when you run the InitializeDesign method in a DSO object from an ASP page in IIS 6.0 Q888096 KB888096 November 21, 2006
• 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 21, 2006
• 885928 FIX: You may receive an "Error 132 – Error during Commit, Server will restart to preserve data consistency" error message when you try to perform an incremental update on a virtual dimension for a cube in SQL Server 2000 Analysis Services Q885928 KB885928 November 21, 2006
• 885426 FIX: You receive an "Analysis Server Error: Connection to the server is lost" error message when you suspend and then resume operations on a cube in SQL Server 2000 Analysis Services Q885426 KB885426 November 21, 2006
• 885421 FIX: You may experience slow performance when you use the VBA CDate function in a calculated member in SQL Server 2000 Analysis Services Q885421 KB885421 November 21, 2006
• 884844 FIX: You may receive an error message when you use the GetSchemaDataSet function to obtain cube metadata in Analysis Services Q884844 KB884844 November 21, 2006
• 884040 FIX: An MDX query returns unchanged data when you try to perform an incremental update on a virtual dimension that is used in a remote partition for a cube in SQL Server 2000 Analysis Services Q884040 KB884040 November 21, 2006
• 883656 The MSSQLServerOLAPService service may stop and then restart when you incrementally update dimensions in Analysis Services Q883656 KB883656 November 21, 2006
• 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 21, 2006
• 873386 FIX: The Analysis Services service may restart unexpectedly when you try to process a cube partition that has one or more virtual dimensions Q873386 KB873386 November 21, 2006
• 872783 FIX: Query performance decreases when you run a query against an Analysis Services server that has dynamic security implemented for many users Q872783 KB872783 November 21, 2006
• 870620 DTS packages may fail if you run multiple DTS packages that contain Analysis Services Processing tasks at the same time Q870620 KB870620 November 21, 2006
• 843519 FIX: The Analysis Services service may stop unexpectedly when you run a complex MDX query after you set the Cache Policy connection property to 7 Q843519 KB843519 November 21, 2006
• 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 21, 2006
• 843026 BUG: You receive an error message when you try to deny access to a dimension member for a cube role by using a custom rule in Analysis Manager Q843026 KB843026 November 21, 2006
• 842859 FIX: Drillthrough operations on a cube fail if the dimension table has been assigned an alias Q842859 KB842859 November 21, 2006
• 842708 FIX: No warning dialog box appears when changes are made to the member properties in a dimension Q842708 KB842708 November 21, 2006
• 842707 FIX: Changes to the member properties structure in SQL Server 2000 Analysis Services can cause incorrect results or service failures Q842707 KB842707 November 21, 2006
• 841856 FIX: A memory leak occurs when you run queries in the same connection in Analysis Services Q841856 KB841856 November 21, 2006
• 841752 Analysis Services MDX queries that include VBA functions may be slower than expected if a mapped drive is in the search path Q841752 KB841752 November 21, 2006
• 841178 FIX: The Analysis Services service may shut down if the Cache Policy connection property's value is set to 7 Q841178 KB841178 November 21, 2006
• 840223 FIX: The Analysis server computer stops responding when you process dimensions and virtual dimensions Q840223 KB840223 November 21, 2006
• 839854 FIX: An MDX query stops responding if the result for an axis contains more than 64,000 members Q839854 KB839854 November 21, 2006
• 838840 FIX: A memory leak occurs in Analysis Services when a VBA function is used in a calculation Q838840 KB838840 November 21, 2006
• 838004 FIX: MDX queries to cubes where real-time updates are enabled may not reflect updates to the relational table Q838004 KB838004 November 21, 2006
• 837982 FIX: Internet Explorer may stop responding or you may receive an error message when you try to connect to Analysis Services by using HTTP or HTTPS Q837982 KB837982 November 21, 2006
• 837724 FIX: An MDX query runs slower when it uses a user-defined function in dynamic security in Analysis Services Q837724 KB837724 November 21, 2006
• 836724 You may receive a "The wizard was interrupted before Microsoft SQL Server Notification Services could be completely installed" message when you try to install SQL Server 2000 Notification Services Q836724 KB836724 November 21, 2006
• 836055 Failures may occur during cube processing if you select a member key column that is not correct Q836055 KB836055 November 21, 2006
• 835975 FIX: Aggregations return Zero values for members of Roles with restricted Measures access Q835975 KB835975 November 21, 2006
• 834844 FIX: The UserName function returns NULL or an empty string in an MDX query or in an MDX expression Q834844 KB834844 November 21, 2006
• 834837 FIX: When using the Microsoft Decision Support Objects (DSO) library to perform a processReaggregate operation on a cube the SQL Server 2000 Analysis Services service may shutdown and then restart Q834837 KB834837 November 21, 2006
• 834777 FIX: Some cubes are not processed by the process database operation Q834777 KB834777 November 21, 2006
• 834495 FIX: Cut-and-paste operations fail with an internal error in Analysis Manager in SQL Server 2000 Analysis Services Q834495 KB834495 November 21, 2006
• 834494 FIX: Calculated members may return incorrect results for dynamic formulas Q834494 KB834494 November 21, 2006
• 834491 FIX: The UPDATE CUBE MDX statement writes the remainder value of the writeback formula to a NULL cell Q834491 KB834491 November 21, 2006
• 834490 FIX: MDX queries on a cube that contains a virtual dimension may not reflect changes after the incremental update on the virtual dimension Q834490 KB834490 November 21, 2006
• 834419 FIX: You cannot exclude members of the computer Administrators group from the OLAP Administrators group Q834419 KB834419 November 21, 2006
• 834112 You receive a "Move data process" error message when you try to install an Analysis Services service pack Q834112 KB834112 November 21, 2006
• 833980 FIX: The initialization phase of Analysis Services database processing takes several hours to complete Q833980 KB833980 November 21, 2006
• 833342 FIX: The Analysis Services service may shut down and then restart when you run MDX queries on a remote computer Q833342 KB833342 November 21, 2006
• 833162 FIX: An incorrect set of dimension members may be returned in Analysis Services Q833162 KB833162 November 21, 2006
• 831667 FIX: The writeback operation is not successful when you try to update a cube in SQL Server 2000 Analysis Services Q831667 KB831667 November 21, 2006
• 831665 FIX: A drillthrough request may cause a SQL Server 2000 Analysis Services server to shut down Q831665 KB831665 November 21, 2006
• 831655 FIX: An MDX Query on a Real-Time Update Enabled Cube Returns Results from the Client-Side Cache Q831655 KB831655 November 21, 2006
• 831652 FIX: A query on a real-time cube may block real-time updates for other cubes Q831652 KB831652 November 21, 2006
• 831352 PRB: Calculated Member Returns Incorrect Value When You Divide a Currency Data Type Measure with a Real Data Type Measure Q831352 KB831352 November 21, 2006
• 831046 FIX: Incorrect Results Are Returned If a Slice Occurs on a Virtual Dimension in a Cube That Has Multiple Partitions Q831046 KB831046 November 21, 2006
• 831045 FIX: A Memory Leak Occurs When You Incrementally Update Dimensions That Contain Member Properties Q831045 KB831045 November 21, 2006
• 831044 FIX: The OpenSchema Method Returns Null for the Custom Member Property of a Parent-Child Dimension Level Q831044 KB831044 November 21, 2006
• 831042 FIX: Analysis Services crashes if you incrementally update a non-changing dimension Q831042 KB831042 November 21, 2006
• 830894 FIX: An embedded quotation mark in the MDX ALTER CUBE command removes the character that comes before the quotation mark Q830894 KB830894 November 21, 2006
• 830393 FIX: Queries Return Empty Result Sets If a Calculated Member Is Defined by Using the NonEmptyCrossjoin Function Q830393 KB830393 November 21, 2006
• 829906 An Office Web Components 10 PivotChart May Crash When You Open It Q829906 KB829906 November 21, 2006
• 829899 FIX: Delete of Dimension Member in Write-Enabled Dimension May Cause Service to Restart Q829899 KB829899 November 21, 2006
• 829897 FIX: Dimension Security on a Cube with Distinct Count May Return #ERR Q829897 KB829897 November 21, 2006
• 829747 PRB: OLAP Cubes in an Analysis Services Database Are Not Accessible After You Apply Analysis Services SP3 Q829747 KB829747 November 21, 2006
• 829738 You Receive an Error Message When You Try to Register or Connect to an Analysis Services Computer as a Domain User Q829738 KB829738 November 21, 2006
• 829091 BUG: Database Components Are Not Installed When You Install SQL Server Notification Services Q829091 KB829091 November 21, 2006
• 829081 FIX: MDX query results may not be correct if dimension security is defined on a dimension Q829081 KB829081 November 21, 2006
• 829051 FIX: A Memory Leak May Occur When Many Connections Are Made in Analysis Services Q829051 KB829051 November 21, 2006
• 829050 FIX: Calculated Member in WHERE Clause May Cause Empty Result Q829050 KB829050 November 21, 2006
• 828279 How To: Traverse an ADO MD Cellset Object by Using Visual C# .NET Q828279 KB828279 November 21, 2006
• 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 21, 2006
• 827916 FIX: Dimension Calculated Member Caption Blank If Dimension Uses Caption Type Member Property Q827916 KB827916 November 21, 2006
• 827899 FIX: Prevent Analysis Services Processing Requests from Blocking Queries Q827899 KB827899 November 21, 2006
• 826524 FIX: NON EMPTY Keyword Phrase May Not Remove All Empty Members from a Virtual Cube Q826524 KB826524 November 21, 2006
• 826310 BUG: You cannot connect to a SQL Server 2000 Analysis Services computer after you install Analysis Services Service Pack 3 Q826310 KB826310 November 21, 2006
• 826307 PRB: Slow Query Performance Occurs When You Run an MDX Query That References Dimension Member Properties Q826307 KB826307 November 21, 2006
• 825713 Decimal data type values and Numeric data type values in OLAP cubes are rounded off Q825713 KB825713 November 21, 2006
• 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 21, 2006
• 824219 FIX: You Receive an Incorrect Result in a MOLAP Cube That Uses the Float Datatype Column for a Measure Q824219 KB824219 November 21, 2006
• 823474 FIX: An MDX Query May Fail If It References a Dimension That Has Been Loaded by the VLDM Q823474 KB823474 November 21, 2006
• 823373 FIX: Access violations may occur in Analysis Services if real-time ROLAP cubes are stressed Q823373 KB823373 November 21, 2006
• 822839 FIX: #ERR Is Returned for Cells That Are Sourced from Remote Partitions Q822839 KB822839 November 21, 2006
• 822838 FIX: "Unable to Expand Node" Error Message When You Try to Expand a Member Node Q822838 KB822838 November 21, 2006
• 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 21, 2006
• 822652 FIX: HTTP Connections to Analysis Services Server Computers Running Windows Server 2003 Are Slow Q822652 KB822652 November 21, 2006
• 822651 FIX: Remote Partitions Are Marked as "Unprocessed" After You Perform an Incremental Update of a Virtual Dimension Q822651 KB822651 November 21, 2006
• 822650 FIX: An UPDATE CUBE Statement Returns an Error When You Try to Update a Measure in a Virtual Cube Q822650 KB822650 November 21, 2006
• 822277 FIX: Analysis Services Service Quits During Processing and Does Not Restart Q822277 KB822277 November 21, 2006
• 821752 FIX: Restricted Client Property Is Not Available in the Connection Properties Collection Q821752 KB821752 November 21, 2006
• 821479 FIX: Analysis Client Sends Calculated Member Definitions When a Query Is Sent to a Server Q821479 KB821479 November 21, 2006
• 821463 FIX: Pending Writeback May Cause Results That Are Not Accurate Q821463 KB821463 November 21, 2006
• 821104 FIX: Query Results Are Not Correct After You Perform an Incremental Update of a Changing Dimension and a Virtual Dimension Q821104 KB821104 November 21, 2006
• 820358 FIX: A Lazy Aggregation Might Fail After an Incremental Update of a Changing Dimension Q820358 KB820358 November 21, 2006
• 819757 FIX: MDX Calculated Members That Return String Values May Cause an Empty Result Set Q819757 KB819757 November 21, 2006
• 819609 FIX: The XML for Analysis Services provider result set does not contain the hierarchy name Q819609 KB819609 November 21, 2006
• 819541 BUG: MDX Query Does Not Return Correct Results When Writeback Data Is Not Committed Q819541 KB819541 November 21, 2006
• 819020 FIX: Incremental Update Process May Fail On Cubes or Partitions That Use the HOLAP Storage Mode Q819020 KB819020 November 21, 2006
• 818969 FIX: EstimatedRows Property of Aggregation is Not Updateable Q818969 KB818969 November 21, 2006
• 818963 How to prevent a session reset on HTTP connections for Analysis Services 2000 Service Pack 3 Q818963 KB818963 November 21, 2006
• 818389 BUG: Unexpected Behavior Occurs When You Perform a Drill Down of a Parent-Child Dimension That Has a Ragged Hierarchy Q818389 KB818389 November 21, 2006
• 817297 FIX: EstimatedRows Property of Aggregation is Set to Zero for Aggregations That Have Several Dimension Members Cubes with Many Leaf Dimension Members Q817297 KB817297 November 21, 2006
• 817285 FIX: You may receive an error message after you run an MDX query that contains a user-defined function Q817285 KB817285 November 21, 2006
• 816651 FIX: Use of the NON EMPTY Keyword on Sets with More Than 2 Billion Members Might Cause Analysis Server to Restart Q816651 KB816651 November 21, 2006
• 816480 FIX: Cannot Use User-Defined Functions in Dimension Security Definitions Q816480 KB816480 November 21, 2006
• 815486 PRB: Analysis Services with SQL Server Service Pack 3 Cannot Connect to Analysis Services Builds Between 8.00.0671 and 8.00.0727 Q815486 KB815486 November 21, 2006
• 815291 FIX: A Delay Occurs During a Writeback Operation If You Do Not Have the Correct Permissions Q815291 KB815291 November 21, 2006
• 814956 FIX: The CREATE CUBE Command Fails If You Use the TYPE TIME Dimension Q814956 KB814956 November 21, 2006
• 814462 PRB: Analysis Services 2000 Service Pack 3 Setup Is Not Successful Because the RootDir Value Is Missing Q814462 KB814462 November 21, 2006
• 814414 FIX: Error message when parallel processing activity or a high degree of concurrent administrative activity occurs on SQL Server 2000 Analysis Services SP3: "Error: Attempting to connect to server" Q814414 KB814414 November 21, 2006
• 814252 FIX: "Error Reporting" Dialog Box Remains Open During Analysis Services 2000 Service Pack 3 Silent Installation Q814252 KB814252 November 21, 2006
• 812601 PRB: Cannot process a cube after you install SQL Server 2000 Analysis Services Service Pack 3 Q812601 KB812601 November 21, 2006
• 810440 FIX: MDX Queries Return "#Err" as the Result Set When You Enable "Visual Totals" on Private Parent-Child Dimension Q810440 KB810440 November 21, 2006
• 810435 FIX: Writeback on a Virtual Cube Does Not Always Work Q810435 KB810435 November 21, 2006
• 810430 FIX: WriteBack to an OLAP Cube Is Slow with Two or More Simultaneous Users Q810430 KB810430 November 21, 2006
• 329480 FIX: Property_Content_Type Is Set to 0 in Local Cube When You Use the CREATE GLOBAL CUBE Statement Q329480 KB329480 November 21, 2006
• 329479 FIX: Cannot Set Description for Dimensions and Measures by Using the CREATE GLOBAL CUBE Statement Q329479 KB329479 November 21, 2006
• 328573 PRB: User in Two Roles May Cause Query Execution Failure Q328573 KB328573 November 21, 2006
• 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 21, 2006
• 324426 BUG: FoodMart 2000 Does Not Install When You Install Analysis Server on Windows XP Professional Chinese Version Q324426 KB324426 November 21, 2006
• 324040 INF: Connect to Analysis Services By Using "SSPI = Anonymous" on Windows XP Q324040 KB324040 November 21, 2006
• 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 Services Q320730 KB320730 November 21, 2006
• 320723 FIX: Calculated Members, Actions, and Named Sets That Are Created from a Decision Support Objects Application Are Not Displayed Q320723 KB320723 November 21, 2006
• 319641 FILE: New Syntax Available to Create Local Cubes Q319641 KB319641 November 21, 2006
• 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 21, 2006
• 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 21, 2006
• 318596 FIX: Analysis Services HTTP Connections Return "Access Denied" Error Messages Q318596 KB318596 November 21, 2006
• 317562 FIX: The calculated member that uses the ValidMeasure function may return an incorrect value in a virtual cube Q317562 KB317562 November 21, 2006
• 313279 FIX: Unable to drill through cell in an Analysis Services cube and connection to server terminates Q313279 KB313279 November 21, 2006
• 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 21, 2006
• 313043 FIX: Creation of Local Cube Fails Q313043 KB313043 November 21, 2006
• 309181 FIX: Incorrect Results Return When You Query a Virtual Cube Q309181 KB309181 November 21, 2006
• 304215 How to create multiple distinct count measures in a single cube Q304215 KB304215 November 21, 2006
• 303897 FIX: Cubes Unavailable During Incremental Update Q303897 KB303897 November 21, 2006
• 301537 How To Obtain the Current Day with a MDX Query or Expression in SQL Server 2000 Analysis Services Q301537 KB301537 November 21, 2006
• 301472 FIX: Assertion Occurs When You Use VT_UI4 Integer for SERVICE_TYPE_ID with the OpenSchema Method Q301472 KB301472 November 21, 2006
• 299926 INF: Writebacks That Use Multi-Hierarchies Must Specify All Hierarchies Q299926 KB299926 November 21, 2006
• 299905 INF: Data Types Used by Analysis Services Q299905 KB299905 November 21, 2006
• 299797 Sample: Analysis Services Writeback Sample Q299797 KB299797 November 21, 2006
• 299616 FIX: Error Training Mining Model That Has Many Input Attributes and Many Rows of Data Q299616 KB299616 November 21, 2006
• 299383 FIX: Incorrect Results Returned from MDX Query When Default Member Is Defined by User Q299383 KB299383 November 21, 2006
• 299005 FIX: Analysis Server shuts down when updating virtual dimension after structure changes Q299005 KB299005 November 21, 2006
• 298711 FIX: Unable to Browse Data Mining Model that has the Same Name as a Cube Q298711 KB298711 November 21, 2006
• 298701 FIX: Error When Regional Setting Is Different Than Operating System Language Q298701 KB298701 November 21, 2006
• 298700 FIX: Syntax Error Occurs When You Use EQUAL_AREAS or THRESHOLDS Keyword for DISCRETIZED Method Q298700 KB298700 November 21, 2006
• 298688 FIX: "Members With Data" Property Produces Wrong Result with Unary Operators in Parent-Child Dimension Q298688 KB298688 November 21, 2006
• 298681 FIX: Drillthrough Query on a Virtual Cube Shows Incorrect Results or Error Q298681 KB298681 November 21, 2006
• 298679 FIX: NonEmptyCrossJoin Queries Cannot Run Remotely on the Server Q298679 KB298679 November 21, 2006
• 298600 FIX: Partition Stops Inheriting FromClause Property from Parent Cube Q298600 KB298600 November 21, 2006
• 298595 FIX: Order and Format of Dimension Members Not Maintained After Processing Q298595 KB298595 November 21, 2006
• 298594 FIX: Cubes with a Remote Partition and Parent-Child Dimension Display #ERR Q298594 KB298594 November 21, 2006
• 298485 FIX: Incremental Update of Cube with Distinct Measure Causes Analysis Server to Shut Down Q298485 KB298485 November 21, 2006
• 298443 FIX: Analysis Services Always Uses Visual Totals for Restricted Dimensions Q298443 KB298443 November 21, 2006
• 297933 FIX: Full Process of a Remote Partition Unprocesses Other Remote Partitions in Same Server Q297933 KB297933 November 21, 2006
• 297823 FIX: Incorrect Data Displays in PivotTable When it is Filtered and AutoCalc is Set to Max or Min Q297823 KB297823 November 21, 2006
• 297799 PRB: Empty Cells Are Returned by a MDX Query that Uses a Non Empty Clause Q297799 KB297799 November 21, 2006
• 297338 FIX: Division by Zero Produces Zero as a Result for a Calculated Member Q297338 KB297338 November 21, 2006
• 297248 FIX: Server Shutdown When Processing a Cube with Private, Virtual, and Shared Dimensions Q297248 KB297248 November 21, 2006
• 297232 FIX: Cannot Browse Cubes or Process Mining Model After You Install Analysis Services 2000 RTM Q297232 KB297232 November 21, 2006
• 297205 FIX: A remote Cut and Paste of a SQL Server 7.0 cube or dimension in Analysis Manager causes an error Q297205 KB297205 November 21, 2006
• 297179 FIX: OLAP Service Fails to Start After Changing Sort Order to Binary on Japanese Windows Q297179 KB297179 November 21, 2006
• 296929 FIX: Creation of Ad Hoc Data Mining Models Fails with Mining Execution Location=3 Q296929 KB296929 November 21, 2006
• 296915 FIX: Access Violation When Processing a Database That Was Restored Over Existing Database Q296915 KB296915 November 21, 2006
• 296905 FIX: Data Mining Provider Stops Responding When Using Row Navigation through OLE DB API Q296905 KB296905 November 21, 2006
• 296901 FIX: Cube Editor Stops Responding on Save After Adding Private Dimension Q296901 KB296901 November 21, 2006
• 296774 FIX: DTS Logs Processing Messages Even When Package Logging Is Turned Off Q296774 KB296774 November 21, 2006
• 296762 FIX: DSO Allows Cube Role or Data Mining Role to Be Added Without a Corresponding Database Role Q296762 KB296762 November 21, 2006
• 296652 FIX: Dimension Editor Displays Error Message While Setting Default Member Q296652 KB296652 November 21, 2006
• 296639 FIX: Analysis Services Fails When All Shared Dimensions Are Processed Q296639 KB296639 November 21, 2006
• 296496 FIX: Replace of Fact Table Does Not Display Correct Fact Table Name in Cube Editor Q296496 KB296496 November 21, 2006
• 296420 FIX: Incremental Update of Cube Results in Empty Cube if Partition Was Previously Empty Q296420 KB296420 November 21, 2006
• 296419 FIX: Cannot Set Parent for Calculated Member to Member of Parent-Child Dimension Q296419 KB296419 November 21, 2006
• 296381 FIX: Creating a Local Cube with a Large Number of Measures May Cause Error on the Client Q296381 KB296381 November 21, 2006
• 296380 FIX: IS_DRILLTHROUGH_ENABLED in MDSCHEMA_CUBES Resultset Invalid for Copied Objects Q296380 KB296380 November 21, 2006
• 296378 FIX: Query Using NON EMPTY Clause Fails for Measures with a Large Cellset Q296378 KB296378 November 21, 2006
• 296147 FIX: Errors in Application Center Event Viewer About Analysis Services Performance Counter Q296147 KB296147 November 21, 2006
• 296064 FIX: Analysis Services Cubes Restored From Archive May Show #ERR When Browsed Q296064 KB296064 November 21, 2006
• 295985 FIX: Creating a Local Cube from a Linked Cube May Return Error Q295985 KB295985 November 21, 2006
• 295737 FIX: Analysis Manager Reports Error: Cannot Create Temp Directory Due to Disk Space Problems Q295737 KB295737 November 21, 2006
• 295706 FIX: Virtual Cube Returns Empty Cells if Custom Rule Is Applied Q295706 KB295706 November 21, 2006
• 295683 FIX: Virtual Cube Returns #ERR if You Use Dimension Security and Visual Total Together Q295683 KB295683 November 21, 2006
• 295634 FIX: Server Fails with Query to Cube with Multiple Partitions and Distinct Count Measure Q295634 KB295634 November 21, 2006
• 295537 FIX: Unable to Save Changes to Analysis Services Named Sets Q295537 KB295537 November 21, 2006
• 295463 FIX: Cube Editor Reports Named Set Name Not Valid but Named Set Displays Correctly Q295463 KB295463 November 21, 2006
• 295446 FIX: MSOLAP 8.0 Provider Returns Invalid Property Values for Non-Leaf Members Q295446 KB295446 November 21, 2006
• 295442 FIX: Processing OLAP 7.0 Objects from Analysis Services DTS Task Fails Q295442 KB295442 November 21, 2006
• 294993 FIX: Combination of Order and CrossJoin Functions in MDX Causes Error Q294993 KB294993 November 21, 2006
• 294968 FIX: Error Processing Partitions in Parallel Through DTS May Cause Processing to Fail Q294968 KB294968 November 21, 2006
• 294746 FIX: Error Occurs When Changes are Made to Dimension Security for Very Large Dimensions Q294746 KB294746 November 21, 2006
• 294734 FIX: Invalid Data Displays after Refreshing the Definition of a Cube That Contains Virtual Dimensions Q294734 KB294734 November 21, 2006
• 294703 FIX: Incorrect Data in Local Cube Using Custom Rollup with Parent Child Dimension and UNARY Operator Q294703 KB294703 November 21, 2006
• 294664 FIX: Timeout Error While Browsing Data from Analysis Manager Q294664 KB294664 November 21, 2006
• 294535 FIX: Real-Time Cubes Fail to Process with a Measure Defined as Distinct Count Q294535 KB294535 November 21, 2006
• 294371 FIX: Cubes and Dimensions Not Visible After Upgrading From OLAP Services 7.0 to Analysis Services 8.0 Q294371 KB294371 November 21, 2006
• 294285 FIX: Processing All Dimensions May Fail with Very Large Dimensions Q294285 KB294285 November 21, 2006
• 294276 FIX: "Subscript Out of Range" Error Message in Usage Analysis Report Q294276 KB294276 November 21, 2006
• 293815 INF: Dimension Rules for Security Role Not Saved When Programmatically Set Q293815 KB293815 November 21, 2006
• 293782 BUG: Can Only Administer Analysis Server if User is a Member of Administrators Group Q293782 KB293782 November 21, 2006
• 293776 FIX: Cube Remains in Repository Database After Restore of Archived Database Without Cube Q293776 KB293776 November 21, 2006
• 293627 BUG: Failure to migrate repository from Meta Data format to SQL Server 7.0 format Q293627 KB293627 November 21, 2006
• 293616 FIX: How to Migrate Repository from Meta Data Format to SQL Server Database Format Q293616 KB293616 November 21, 2006
• 293612 FIX: Remote Partitions Require Remote Servers to Run Under OLAP Administrators Account Q293612 KB293612 November 21, 2006
• 293609 FIX: Drill-Through Returns Incorrect Data When Dimension Tables Are Aliased in Dimension Editor Q293609 KB293609 November 21, 2006
• 293528 FIX: Drill-Through Fails if Dimension Table Has an Alias in the Cube Q293528 KB293528 November 21, 2006
• 293516 FIX: Processing of Remote Partition Fails When Dimension and Fact Table Are in Different Data Sources Q293516 KB293516 November 21, 2006
• 293463 FIX: ASP Error 0115 Occurs When Connecting Through HTTP to Analysis Server on Windows NT 4.0 Q293463 KB293463 November 21, 2006
• 293318 FIX: Analysis Services DTS Task Gets Timeout Error During Incremental Update Q293318 KB293318 November 21, 2006
• 293195 FIX: Use of the Colon Operator to Define a Range of Members May Cause Incorrect Results in MDX Query Q293195 KB293195 November 21, 2006
• 291563 FIX: Analysis Server HTTPS Connections Slower Than HTTP and TCP/IP Connections Q291563 KB291563 November 21, 2006
• 291374 FIX: Creation of Local Cube with More Than 202 Measures May Fail Q291374 KB291374 November 21, 2006
• 291364 FIX: Query Performance Slower When Client Locale Differs from Server Locale Q291364 KB291364 November 21, 2006
• 290799 BUG: Missing Horizontal Scroll Bar in Cube Browser Q290799 KB290799 November 21, 2006
• 290562 FIX: HTTP Connection Resets Session ID of an ASP Session Object Q290562 KB290562 November 21, 2006
• 290416 BUG: Unable to Drill Down to Next Level with Hide Member if Property Set Q290416 KB290416 November 21, 2006
• 289804 FIX: Dimension Wizard Generates Unusable Custom Rollup Formula with Private Parent-Child Dimension Q289804 KB289804 November 21, 2006
• 289748 BUG: Missing Values For Database Event Constants Q289748 KB289748 November 21, 2006
• 288890 PRB: Incompatible Repository Error Message Occurs After Installation of DSO on Client Computer Q288890 KB288890 November 21, 2006
• 283564 BUG: Alias Parameters Do Not Work with Oracle Databases Q283564 KB283564 November 21, 2006
• 282966 DTS Package Fails with Dynamic Properties Task and OLAP Processing Task Q282966 KB282966 November 21, 2006
• 279490 FIX: Analysis Services 2000 Does Not Support Security Account Delegation Q279490 KB279490 November 21, 2006
• 278239 FIX: Extreme Memory Usage When Adding Many Security Roles Q278239 KB278239 November 21, 2006
• 273495 The Cluster Count property may not match the actual number of clusters displayed in the Mining Model Editor Q273495 KB273495 November 21, 2006
• 169377 How to access SQL Server in Active Server Pages Q169377 KB169377 November 20, 2006
• 811479 SQL Server Desktop Engine 2000 Setup fails when you log on with an account that has administrative user rights by using the fast user switching operation in Windows XP Q811479 KB811479 November 14, 2006
• 325289 FIX: New functionality for incremental update of changing dimensions Q325289 KB325289 November 2, 2006