1) 10/11/2004 307945307945  307945.html">INF: How to Carry Balances Forward for Display in a Balance Sheet.
(307945) - Balance Sheets are a common means of reporting cumulative financial data for a distinct time period. This article explains how to use calculated members to provide the necessary functionality.

2) 10/8/2004 306756306756  306756.html">PRB: Unable to Display Visual Totals Using the PivotTable Component
(306756) - When you use the PivotTable component and you choose the option to calculate totals based on visible items only, you may receive the following error message: The data source does not support totalling only visible items.

3) 10/7/2004 870654870654  870654.html">FIX: You may receive a 547 error message when you try to update an instance and application databases of SQL Server 2000 Notification Services by using the NSControl Update command
(870654) - Describes a hotfix for the 547 error message that you may receive when you run the NSControl Update command to re-create a distributor in the NSDistributors table.

4) 10/7/2004 884593884593  884593.html">SQL Server 2000 may overcommit physical memory on computers that are running Windows XP
(884593) - Describes a problem that occurs when SQL Server 2000 may commit more memory than is physically available on a computer that is running Windows XP. Includes a resolution for the problem.

5) 9/30/2004 311528311528  311528.html">BUG: Infinite Recursion Error with Parent-Child Dimension and Custom Member
(311528) - When you view data associated with a custom member of a parent-child dimension, the cell values may display as "#Err". When you examine the cell properties of any of the custom members, you receive the following error message: Infinite recursion...

6) 9/30/2004 304529304529  304529.html">INF: MDX: How to Test for the Top Most Level in a Hierarchy
(304529) - When you traverse a dimension through a Multidimensional Expressions (MDX), you may have to determine if you are at the top most level of the hierarchy. This article shows you four MDX expressions that allow you to find out if you are at the top most...

7) 9/30/2004 296098296098  296098.html">FIX: xp_sendmail Fails with the @attach_results Parameter on SQL Server 2000 Personal Edition
(296098) - The xp_sendmail extended stored procedure may raise the following error if you try to send query results by e-mail using the @attach_results parameter from SQL Server 2000 Personal Edition: Server: Msg 18024, Level 16, State 1, Line 0 xp_sendmail:...

8) 9/29/2004 306397306397  306397.html">How To Use Excel with SQL Server Linked Servers and Distributed Queries
(306397) - SQL Server supports connections to other OLE DB data sources on a persistent or an ad hoc basis. The persistent connection is known as a linked server; an ad hoc connection that is made for the sake of a single query is known as a distributed query....

9) 9/29/2004 307336307336  307336.html">How to change a clustered SQL Server Network Name
(307336) - Cluster Administrator provides a method to rename cluster resources. To do this, right-click the resource in Cluster Administrator and click Rename . However, if you rename the SQL Server Network Name resource, a variety of situations could occur, the...

10) 9/28/2004 304337304337  304337.html">INF: How to Control a Member's Unique Name
(304337) - In Analysis Services a Member's Unique Name may be different depending on the setting of the MDX Unique Name Style connection string property of the Microsoft OLE DB Provider for OLAP 8.0. This article describes the different formats of the Member's...

11) 9/27/2004 305127305127  305127.html">PRB: How to Generate a Snapshot of a Published Table and Apply It to the Subscribers
(305127) - SQL Server 2000 enables replication of declared referential integrity (DRI) to Subscribers through the initial snapshot. The addition of this feature represents a significant performance enhancement for SQL Server 2000 as compared to other versions,...

12) 9/27/2004 304118304118  304118.html">INF: How To Perform Time Series Calculations
(304118) - Time series calculations are frequently required in business and financial reports. Multidimensional expressions (MDX) provide the following time oriented functions to perform time series calculations: YTD QTD MTD WTD LastPeriods PeriodsToDate This...

13) 9/27/2004 299937299937  299937.html">FIX: Changes to Indexed View Article of a Transactional Publication Are Not Saved
(299937) - When editing the properties of an indexed view article that is part of a transactional publication, changes made to the Replace INSERT commands with this stored procedure call , Replace UPDATE commands with this stored procedure call , and Replace...

14) 9/24/2004 301934301934  301934.html">INF: MDX: How to Determine the First or Last Member with Data
(301934) - In some applications, it is useful to find the first or last dimension member that has data associated with it. This article illustrates how to use the HEAD() , TAIL() , and UNION() functions to return the first and last members of a dimension that...

15) 9/24/2004 301909301909  301909.html">INF: How to Overcome the 32 KB Limit for SQL Expressions
(301909) - Analysis Services limits the length of SQL expressions to 32 KB. Some applications require complex SQL Case expressions to define member names and keys, which would exceed the 32 KB limit. This article explains how you can work around the 32 KB limit.