46) 7/13/2004 842859842859  842859.html">FIX: Drillthrough operations on a cube fail if the dimension table has been assigned an alias
(842859) - Describes a problem that occurs when drillthrough operations on a cube fail if the dimension table has been assigned an alias. Includes a hotfix that you can use to resolve the problem.

47) 7/13/2004 867880867880  867880.html">FIX: Merge Agent may fail with an "Invalid character value for cast specification" error message
(867880) - Fixes a problem with the Merge Agent that may cause errors while the Merge Agent enumerates changes.

48) 7/10/2004 822852822852  822852.html">An instance of SQL Server 2000 may not start successfully after you restore the model database by using the WITH NORECOVERY option
(822852) - When you restore the model database by using the WITH NORECOVERY option, the database may be left in an unrecovered state, and the instance of SQL Server will not start. To resolve this problem, clear the "Loading" status of the model database.

49) 7/9/2004 823429823429  823429.html">FIX: You receive error message 7410 when you use a distributed query as a query parameter for the xp_sendmail stored procedure or the sp_makewebtask stored procedure in SQL Server 2000
(823429) - This article discusses that running a distributed query as a part of the xp_sendmail stored procedure or the sp_makewebtask stored procedure may cause error 7410. To resolve the problem, install the hotfix that is mentioned in the article.

50) 7/9/2004 837816837816  837816.html">FIX: You receive an error when you try to update the fields in the dataset of a report in Report Designer
(837816) - Fixes the problem in Report Designer that occurs when you try to refresh the fields in a dataset that uses the Oracle data extension to call an Oracle stored procedure. Requires that you install Reporting SP 1 to resolve the problem.

51) 7/3/2004 289683289683  289683.html">INF: NoRemapPipes Error Message Occurs in System Log when You Use SQL Server 2000 on a Windows 2000 Cluster
(289683) - When SQL Server 2000 is installed on a Microsoft Windows 2000 Cluster, the following error message appears in the System log: The value named NoRemapPipes in the server's Registry key LanmanServer\Parameters was invalid. The value was ignored, and...

52) 7/1/2004 309450309450  309450.html">FIX: Inconsistent Results Reported by TOP N Using Full-Text CONTAINSTABLE
(309450) - When performing a CONTAINSTABLE query against a full-text indexed table using the TOP N syntax to return the highest ranked hits, the query may return inconsistent results.

53) 7/1/2004 306408306408  306408.html">INF: Use of Multiple Hierarchies Versus the Creation of Separate Hierarchies
(306408) - This article list three reasons why it is beneficial to create multiple hierarchies in a single dimension rather than individual dimensions for each hierarchy.

54) 7/1/2004 291235291235  291235.html">FIX: Query Analyzer Hangs After You Drag & Drop Files Into the Query Editor and You Close One of the Newly Created Windows
(291235) - If you drag and drop more than 50 files at one time into the Editor pane of the Query Analyzer, a new query editor opens for each of the files. If you then attempt to close one of the windows by clicking the Close button of the query window, Query...

55) 6/30/2004 306191306191  306191.html">PRB: Drillthrough Queries Return More Rows than Expected If Cube Schema Is Optimized
(306191) - Drillthrough queries in Analysis Services may return more rows than expected if the cube schema is optimized and the drillthrough query data set includes columns from a dimension table that had it's join removed by the schema optimization process.

56) 6/30/2004 304213304213  304213.html">INF: Different Kinds of Analysis Services Timeouts
(304213) - There are several kinds of timeout objects in the Decision Support Object (DSO) object model. This article outlines the difference between the different timeout objects.

57) 6/30/2004 306039306039  306039.html">PRB: Long Running OLAP Queries do not Return Data When Connected Through HTTP
(306039) - When you run a long running MDX query against an Analysis Services server through an HTTP or HTTPS connection, the client may never receive the results of the query. However, if you run the same query from a standard TCP/IP connection to the server,...

58) 6/30/2004 295732295732  295732.html">INF: Creating Databases or Changing Disk File Locations on a Shared Cluster Drive on Which SQL Server 2000 was not Originally Installed
(295732) - After you install a SQL Server 2000 virtual server instance, you may want to create databases, or move existing data or log files onto a secondary shared cluster disk. To create databases, or move existing data or log files, the other disk that SQL...

59) 6/30/2004 300183300183  300183.html">FIX: SQL Server Cluster Resource Fails to Come Online Until Cluster Service Is Restarted
(300183) - If the SQL Server cluster resource is in an "online pending" state and the cluster service sends a termination request to the resource, the resource may not successfully come online again on the node until the cluster service is restarted. The cluster...

60) 6/29/2004 322677322677  322677.html">BUG: You Receive an Error Message If the Member Caption Is Different from the Member Name
(322677) - When you run a Multidimensional Expressions (MDX) query that references dimension properties, you receive an error message that is similar to the following one: Unable to open cellset Dimension property 'store.[store name].[store manager]' was not...