SQL Server 2000 articles, fixes and updates - February 2007

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

• 316749 There may not be enough virtual memory when you have a large number of databases in SQL Server Q316749 KB316749 February 28, 2007
• 301520 Error message when you install SQL Server cluster on Windows Server 2003-based computers where Terminal Services is installed: "Setup failed to perform required operations on the cluster nodes" Q301520 KB301520 February 28, 2007
• 828343 Support WebCast: Dynamic Dimension Security in Microsoft SQL Server 2000 Analysis Services Q828343 KB828343 February 27, 2007
• 817509 Support WebCast: Microsoft SQL Server: Delivering Messages with SQL Server 2000 Notification Services Q817509 KB817509 February 27, 2007
• 815337 Support WebCast: Microsoft SQL Server 2000: Reading Execution Plans in SQL Server 2000 Q815337 KB815337 February 27, 2007
• 814324 Support WebCast: Microsoft SQL Server 7.0 and SQL Server 2000 Indexes Q814324 KB814324 February 27, 2007
• 273791 XADM: MDAC 2.6 Breaks ADO MoveNext() Function with Exchange 2000 Q273791 KB273791 February 27, 2007
• 814109 How to Install SQL Server 2000 SP3 or Security Patch MS02-061 with Commerce Server Q814109 KB814109 February 23, 2007
• 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 February 23, 2007
• 315823 How To Execute Distributed Transaction Using ODBC API with SQL Server Q315823 KB315823 February 23, 2007
• 313173 Sample connection pool manager for use with Microsoft SQL Server 2000 Driver for JDBC Q313173 KB313173 February 23, 2007
• 311836 FIX: SQL Server Driver Fails to Connect over TCP/IP Using Three Parameters in Address Keyword Q311836 KB311836 February 23, 2007
• 310663 PRB: SQLBrowseConnect Does Not Enumerate SQL Server 7.0 Servers Q310663 KB310663 February 23, 2007
• 308264 BUG: SQLDescribeCol Returns Wrong Column Size in a Complex Union Query with Parameters Q308264 KB308264 February 23, 2007
• 308211 FIX: SQLDescribeCol Returns Wrong Column Size in a Union Query with Parameters Q308211 KB308211 February 23, 2007
• 306341 FIX: MDX: TopCount Function Returns "Unable to open cellset Connection to the server is lost" Error Message Q306341 KB306341 February 23, 2007
• 306266 FIX: Updates to Distributed Partitioned Views May Return Incorrect @@ROWCOUNT Value Q306266 KB306266 February 23, 2007
• 294875 FIX: SQLTables() Function Returns No Data for SQL Server Database Names That Contain Underscore Q294875 KB294875 February 23, 2007
• 291566 FIX: Parallel Plan for Index Creation of Non-Clustered Index May Result in Use of Pages That are not Allocated Q291566 KB291566 February 23, 2007
• 280084 PRB: Parameters.Refresh Fails Using Parameter Token in Nested SQL Q280084 KB280084 February 23, 2007
• 276426 FIX: Msxml2.dll Fails to Register on 32-Processor Computer During MDAC 2.6 Installation Q276426 KB276426 February 23, 2007
• 229929 INFO: Registry Entries and Keywords for SQL Server Connection Strings Q229929 KB229929 February 23, 2007
• 821180 FIX: Introduction of the Cache Ratio2 Parameter Q821180 KB821180 February 22, 2007
• 818504 FIX: JDBC Driver Overwrites Timestamp Parameter Values with the Last Value Set Q818504 KB818504 February 22, 2007
• 817326 FIX: JDBC Driver May Cause Application to Stop Responding During Multiple Transactions Q817326 KB817326 February 22, 2007
• 816824 INF: SQL Server 2000 Evaluation Edition Release A Q816824 KB816824 February 22, 2007
• 815197 FIX: An RDA PUSH of a DELETE Fails if the Primary Key Has a Datetime Column Q815197 KB815197 February 22, 2007
• 814514 Overview of Version 3.0 of the SQL Server 2000 Security Tools Q814514 KB814514 February 22, 2007
• 814461 INF: SQL Server 2000 SQL Check Utility Q814461 KB814461 February 22, 2007
• 814406 FIX: Analysis Server Does Not Release Memory After an Incremental Update Q814406 KB814406 February 22, 2007
• 328876 FIX: Analysis Services Cannot Start and You Receive This Error Message: "MSSQLServerOLAPService service terminated unexpectedly" Q328876 KB328876 February 22, 2007
• 328290 PRB: "Setup Was Unable to Verify the State of the Server for an Upgrade" Error Message When SQL Server Service Pack 2 Setup Stops Responding Q328290 KB328290 February 22, 2007
• 326586 PRB: The Ordering of a Member in a Ragged Hierarchy May Not Be Correct Q326586 KB326586 February 22, 2007
• 325765 "String Data, Length Mismatch" Error Message with ODBC Driver for SQL Server If Application Inserts More Than 400 KB of Text Data Q325765 KB325765 February 22, 2007
• 325687 Embedded SQL for C Application Fails When It Experiences a Lock Timeout Error Q325687 KB325687 February 22, 2007
• 325338 FIX: OLE DB Provider for SQL Server Does Not Cancel a Batch Statement When You Call the Cancel() Method Q325338 KB325338 February 22, 2007
• 325199 FIX: Local Cube Creation Fails If Dimension Member Key and Member Names Are from Different Tables Q325199 KB325199 February 22, 2007
• 324914 SQL Server Connection Fails When RC4 Encryption Is Disabled Q324914 KB324914 February 22, 2007
• 324900 FIX: Recordset.Update Causes Error Message: "Cursor operation conflict" to Occur When You Use Server Side Cursors and an INSTEAD OF Trigger Q324900 KB324900 February 22, 2007
• 324305 BUG: SQL Server Virtual Server Setup Fails and You Receive an Error Message Q324305 KB324305 February 22, 2007
• 323630 How to resolve blocking problems that are caused by lock escalation in SQL Server Q323630 KB323630 February 22, 2007
• 323135 Microsoft SQL Server 2000 - How to set up log shipping (White paper) Q323135 KB323135 February 22, 2007
• 322966 INF: Visual Basic for Applications and Excel Library Functions Are Not listed in MDX Builder Q322966 KB322966 February 22, 2007
• 322965 BUG: Excel Mode Function Returns #ERR in MDX Calculated Member Q322965 KB322965 February 22, 2007
• 322719 INF: Powerful and Accessible Analysis for Business (White Paper) Q322719 KB322719 February 22, 2007
• 322706 INF: Microsoft Corp. SQL Server Analysis Services (White Paper) Q322706 KB322706 February 22, 2007
• 322226 INF: XML for Analysis Specification (White Paper) Q322226 KB322226 February 22, 2007
• 322095 INF: Using Partitions in a SQL Server 2000 Data Warehouse (White Paper) Q322095 KB322095 February 22, 2007
• 321363 How to adjust memory usage by using configuration options in SQL Server Q321363 KB321363 February 22, 2007
• 321271 FIX: Unicode Pattern Matching Returns Incorrect Results Q321271 KB321271 February 22, 2007
• 321255 FIX: ODBC Driver for SQL Server 2000 Incorrectly Returns SQL_SUCCESS on SQLDescribeParam() Q321255 KB321255 February 22, 2007
• 320338 BUG: Starting the SQL Server Agent is Unsuccessful on a Backup Domain Controller Q320338 KB320338 February 22, 2007
• 320304 PRB: A DTS Package That You Save as a Visual Basic File May Fail to Import Tab-Delimited Text Data Q320304 KB320304 February 22, 2007
• 318122 INFO: Using Analysis Server Format Properties with the Office XP PivotTable Component Q318122 KB318122 February 22, 2007
• 317223 FIX: Performance Slows If You Process More Than Two Partitions In Parallel Q317223 KB317223 February 22, 2007
• 315109 FIX: Join of Multiple Tables May Fail with E_OUTOFMEMORY Error Message Q315109 KB315109 February 22, 2007
• 314570 PRB: Cannot Modify Backup Network Share After You Change the Transaction Log Backup Folder Q314570 KB314570 February 22, 2007
• 314309 INF: SQL Server 2000 Service Pack 1 and Service Pack 2 Fixlist for SQL Mail Q314309 KB314309 February 22, 2007
• 314128 FIX: Access violation occurs when an RPC call is made that includes a bit parameter value that is not valid Q314128 KB314128 February 22, 2007
• 313883 BUG: Memory Leak When You Load and Unload the SQL Server ODBC Driver or OLE DB Provider Q313883 KB313883 February 22, 2007
• 313702 The SQL Server service may fail to start with I/O error message 38 in the tempdb database Q313702 KB313702 February 22, 2007
• 313474 BUG: An Insert statement that uses a function to parse a string may receive error message 8626 Q313474 KB313474 February 22, 2007
• 313352 FIX: "Numeric Value Out Of Range" Error Message When You Execute Batch SQL Statements Q313352 KB313352 February 22, 2007
• 313313 FIX: SP1 Regression: A SELECT COUNT(*) From a View That Contains a UNION ALL May Be Significantly Slower or Fail Q313313 KB313313 February 22, 2007
• 311801 BUG: Error 3154 Reported in Log Shipping Restore Job Sporadically Q311801 KB311801 February 22, 2007
• 310882 BUG: sp_resolve_logins Stored Procedure Fails If Executed During Log Shipping Role Change Q310882 KB310882 February 22, 2007
• 310834 Description of common causes of SQL Server error message 844 or error message 845 Q310834 KB310834 February 22, 2007
• 310654 IIS Lock Down Tool may break RDA or Replication that uses Anonymous authentication Q310654 KB310654 February 22, 2007
• 309423 BUG: Analysis Manager Stops Responding During Restore on Remote Server Q309423 KB309423 February 22, 2007
• 308968 FIX: Incorrect Results Occur When You Use Currency Data Type with Very Large Value Q308968 KB308968 February 22, 2007
• 308965 FIX: No Children Members Display in a Ragged Dimension with MDX Compatibility = 1 Q308965 KB308965 February 22, 2007
• 308960 FIX: Copy and Paste of ROLAP Partition May Overwrite Aggregation Tables Q308960 KB308960 February 22, 2007
• 308959 FIX: UPDATE CUBE Statement Allocates Data Incorrectly Q308959 KB308959 February 22, 2007
• 307864 Error message when you connect to an instance of SQL Server: "Cannot open user default database" Q307864 KB307864 February 22, 2007
• 307365 PRB: Cannot Connect Through Analysis Manager Although a Member of Administrator Group Q307365 KB307365 February 22, 2007
• 307288 The SQL Server service and the SQL Server Agent Service fail to start on a stand-alone server Q307288 KB307288 February 22, 2007
• 306909 INF: SQL Server 2000 Service Pack 2 Readme.txt Additions Q306909 KB306909 February 22, 2007
• 306756 PRB: Unable to Display Visual Totals Using the PivotTable Component Q306756 KB306756 February 22, 2007
• 305127 PRB: How to Generate a Snapshot of a Published Table and Apply It to the Subscribers Q305127 KB305127 February 22, 2007
• 304529 INF: MDX: How to Test for the Top Most Level in a Hierarchy Q304529 KB304529 February 22, 2007
• 304118 INF: How To Perform Time Series Calculations Q304118 KB304118 February 22, 2007
• 304060 PRB: SQL Server CE Replication Error Message: 28557 : "The database is in an unusable state. " Q304060 KB304060 February 22, 2007
• 304058 HOWTO: Perform Replication by Using SSCERelay and ActiveSync Q304058 KB304058 February 22, 2007
• 303789 Using MSDE 2000 with SQL Server CE RDA and Replication Q303789 KB303789 February 22, 2007
• 303415 INF: File Size Limitations For Use of Archive/Restore for OLAP Q303415 KB303415 February 22, 2007
• 303229 A transaction log backup job that is created in Database Maintenance Planner fails to execute Q303229 KB303229 February 22, 2007
• 303228 FIX: Queue Reader Agent Fails if the Distributor is a Clustered SQL Server Q303228 KB303228 February 22, 2007
• 302349 HOWTO: Perform RDA Pull by Using SSCERelay and ActiveSync Q302349 KB302349 February 22, 2007
• 302341 INF: New Trace Flag to Enable Singleton Update for Transactional Replication Q302341 KB302341 February 22, 2007
• 301913 BUG: Error Message: "There is not enough space on drive" Occurs When You Extract SQL Server 2000 Downloads Q301913 KB301913 February 22, 2007
• 301456 INF: How to Use OLAP Number Formats with Office Web Components Q301456 KB301456 February 22, 2007
• 301049 PRB: Database Loaded in Standby Mode if No Recovery Mode is Selected from Destination Database Window When You Configure Log Shipping Q301049 KB301049 February 22, 2007
• 300516 Readme.txt files for SQL Server 2000 service packs Q300516 KB300516 February 22, 2007
• 300497 FIX: Log Shipping: Cannot Change Role From Secondary to Primary When Database Names Are Different Q300497 KB300497 February 22, 2007
• 300217 FIX: "Update Index in Background" Option in Change Tracking May Not Work if Very Low Disk Space Detected Q300217 KB300217 February 22, 2007
• 300099 PRB: Restoring Archive from Server with Metadata Format to Server with Access Repository Fails Q300099 KB300099 February 22, 2007
• 300080 BUG: Property Changes in the Merging Changes Tab of an Indexed View Article Are Not Saved Q300080 KB300080 February 22, 2007
• 299937 FIX: Changes to Indexed View Article of a Transactional Publication Are Not Saved Q299937 KB299937 February 22, 2007
• 299903 FIX: sp_scriptpublicationcustomprocs Generates Replication Stored Procedures Q299903 KB299903 February 22, 2007
• 299889 FIX: Full Population May Not Complete if Microsoft Search Service Is Stopped and Restarted Q299889 KB299889 February 22, 2007
• 299362 FIX: Failover of a SQL Virtual Server Causes Problems with Active Directory Integration Q299362 KB299362 February 22, 2007
• 299287 FIX: The Number of Parameters Does Not Match Error Message From Distribution Task Q299287 KB299287 February 22, 2007
• 298810 PRB: Deleting the Last Destination Removes Log Shipping Completely Q298810 KB298810 February 22, 2007
• 298743 BUG: All Changes May Not be Rolled Back when Log Shipping Maintenance Wizard Fails Q298743 KB298743 February 22, 2007
• 297211 PRB: Undocumented Filter Syntax for IReposQuery::GetCollection Method Q297211 KB297211 February 22, 2007
• 296685 FIX: Cannot Execute SELECT COUNT(*) Against DB2 on Mainframe Using Four-Part Name Q296685 KB296685 February 22, 2007
• 295936 FIX: Error Removing Log Shipping on Secondary Database When Database Name Has a Quote Q295936 KB295936 February 22, 2007
• 295748 INFO: SQL Server CE Bits for CEPC Installed Only if Platform Builder 3.0 is Installed Q295748 KB295748 February 22, 2007
• 294999 FIX: SQL Server Fails to Start with \f Option on Computers with Many CPUs Q294999 KB294999 February 22, 2007
• 294287 INF: How to Automate an Archive or Backup of OLAP Database Q294287 KB294287 February 22, 2007
• 292616 FIX: ISQLWCE for PocketPC SH3 Has Incorrect MFC and OLE DLLs Q292616 KB292616 February 22, 2007
• 292586 Backup, copy, and load job information is not updated on the log shipping monitor Q292586 KB292586 February 22, 2007
• 291160 FIX: Books Online Incorrect About Default Value of @terminate for SP_CHANGE_PRIMARY_ROLE Q291160 KB291160 February 22, 2007
• 290787 Error message when you perform a database backup to disk or tape or a database restore from disk or tape: "3266," "3013" Q290787 KB290787 February 22, 2007
• 290644 FIX: DTSRun.exe Causes Access Violation on SMP Computers Q290644 KB290644 February 22, 2007
• 290351 FIX: SQL Server Assertion During Distributed Transaction Q290351 KB290351 February 22, 2007
• 290208 PRB: SQL Server CE Replication or RDA Fails When IIS Uses SHA1 Hashing Algorithm Q290208 KB290208 February 22, 2007
• 289872 PRB: Insufficient Room for Growth in Master or Model Databases May Corrupt the sysdepends Table in the Model Database Q289872 KB289872 February 22, 2007
• 289107 BUG: Incorrect Reference to the Second Virtual Server Instance Name Q289107 KB289107 February 22, 2007
• 288809 How to recover SQL Server after a tempdb database is marked suspect Q288809 KB288809 February 22, 2007
• 288189 FIX: DTS FTP Task May Fail to Download Files After a Network Problem Q288189 KB288189 February 22, 2007
• 287753 PRB: ExOleDB Provider Doesn't Work with SQL Server 2000 DTS Tool Q287753 KB287753 February 22, 2007
• 287737 How to enumerate available instances of SQL Server by using the SQLDMO components Q287737 KB287737 February 22, 2007
• 287651 PRB: Join Filter Causes Inconsistent Rows on SQL Server CE Subscriber Q287651 KB287651 February 22, 2007
• 286775 FIX: Creating a Publication From Within DTSWIZ Fails with "Error 496: General Error" Error Message Q286775 KB286775 February 22, 2007
• 286357 FIX: SQL Server CE Refresh Fixes GUID Generation Problems Q286357 KB286357 February 22, 2007
• 286280 Description of the effect to database recovery after you add or remove database files Q286280 KB286280 February 22, 2007
• 285865 PRB: SQL Server CE Connectivity Application Stops Responding When Network Connection is Dropped Q285865 KB285865 February 22, 2007
• 283844 FIX: DATEADD does not accept scientific notation for the NUMBER argument Q283844 KB283844 February 22, 2007
• 282254 SQL Server service does not start successfully because of a logon failure Q282254 KB282254 February 22, 2007
• 281213 PRB: SQL Server CE Setup on Windows 2000 Error Message: The Installer Was Interrupted Q281213 KB281213 February 22, 2007
• 280514 How To Use AppendChunk and GetChunk with NText Columns in a SQL Server CE Database Q280514 KB280514 February 22, 2007
• 280352 How To Install SQL Server CE from the Command Line and Generate a Log File Q280352 KB280352 February 22, 2007
• 280082 FIX: SQL Server CE Queries with WHERE and ORDER BY Clauses May Run Slow Q280082 KB280082 February 22, 2007
• 279761 How To Use the ADOCE 3.1 Seek Method with SQL Server CE Q279761 KB279761 February 22, 2007
• 279552 How To Delete a SQL Server CE Database in an Application Q279552 KB279552 February 22, 2007
• 279295 FIX: Parallel Index Creation on Large SMP Hardware Can Cause Handled Access Violation Q279295 KB279295 February 22, 2007
• 279123 FIX: SQL Server 2000 Uninstallation May Break SQL Server CE Replication Q279123 KB279123 February 22, 2007
• 276985 How To Use SQL Server CE OLE DB Provider-Specific Properties in eVB Q276985 KB276985 February 22, 2007
• 274255 PRB: ADOXCE Error Message: "..Specified type was invalid" for SQL Server CE Table Q274255 KB274255 February 22, 2007
• 274112 INFO: SQL Server CE Performance Tips and Efficient Memory Handling Q274112 KB274112 February 22, 2007
• 273836 INF: Running OLAP Services on a Domain Controller Q273836 KB273836 February 22, 2007
• 272683 Restore of a database with an incorrect named transaction may leave the database in the loading status in SQL Server 2000 Q272683 KB272683 February 22, 2007
• 272210 INFO: System Tables in SQL Server CE Database Q272210 KB272210 February 22, 2007
• 271931 INFO: Using Multiple Recordsets for Performance with SQL Server CE Database Q271931 KB271931 February 22, 2007
• 271592 INFO: Cannot Create a SQL Server CE Database on Connection.Execute Q271592 KB271592 February 22, 2007
• 270896 INFO: SQL Server CE Query Analyzer Does Not Display Descriptive Data Type Q270896 KB270896 February 22, 2007
• 270119 Error messages when you perform an UPDATE, INSERT, or DELETE Transact-SQL statement on a remote table by using the OpenQuery function: "7357" and "7320" Q270119 KB270119 February 22, 2007
• 270042 Description of SQL Server compatibility collations Q270042 KB270042 February 22, 2007
• 269662 INF: SQL Server 2000 Books Online Information on Distributed Partitioned Views Q269662 KB269662 February 22, 2007
• 269587 Windows Authentication mode is the default security mode after a typical installation of SQL Server 2000 or of SQL Server 2005 Q269587 KB269587 February 22, 2007
• 269541 Error message when you connect to SQL Server if the Windows NT LM Security Support Provider registry key is missing: "cannot generate SSPI context" Q269541 KB269541 February 22, 2007
• 268591 The Sql.log file may consume all disk space and cause SQL Server to run slowly when you turn on ODBC Tracing Q268591 KB268591 February 22, 2007
• 264474 You cannot restore system database backups to a different build of SQL Server Q264474 KB264474 February 22, 2007
• 264154 You must start an instance of SQL Server in single-user mode when you use DBCC CHECKDB/CHECKTABLE with REPAIR options Q264154 KB264154 February 22, 2007
• 262499 How to specify output parameters when you use the sp_executesql stored procedure in SQL Server Q262499 KB262499 February 22, 2007
• 259561 You receive a "Cannot open user default database <ID>. Using master database instead." error message when you connect to a SQL Server database Q259561 KB259561 February 22, 2007
• 246800 How to correctly parse quotation marks in Full Text Search queries Q246800 KB246800 February 22, 2007
• 243899 How to access additional information about errors that are returned when you use the OLE Automation system stored procedures Q243899 KB243899 February 22, 2007
• 239530 You must precede all Unicode strings with a prefix N when you deal with Unicode string constants in SQL Server Q239530 KB239530 February 22, 2007
• 236605 PRB: DTS Wizard may not detect Excel column type for mixed data in SQL Server Q236605 KB236605 February 22, 2007
• 235880 You receive an "Error 605" error message when you run a query with the optimizer hint NOLOCK or you set the transaction isolation level to READ UNCOMMITTED in SQL Server Q235880 KB235880 February 22, 2007
• 234748 You cannot correctly translate character data from a client to a server by using the SQL Server ODBC driver if the client code page differs from the server code page Q234748 KB234748 February 22, 2007
• 231951 INF: Permissions That You Must Have to Administer an OLAP Server Q231951 KB231951 February 22, 2007
• 199037 How to capture error messages that are sent to clients from an instance of SQL Server Q199037 KB199037 February 22, 2007
• 198891 How to run a DLL-based COM object outside the SQL Server process Q198891 KB198891 February 22, 2007
• 152801 Examples of how to use Sp_OA pocedures and the SQLOLE.Transfer (or SQLDMO.Transfer) object Q152801 KB152801 February 22, 2007
• 137637 Microsoft ODBC SQL Server Driver is not certified for use against Sybase SQL Servers Q137637 KB137637 February 22, 2007
• 118552 Description of handling deadlock conditions in SQL Server Q118552 KB118552 February 22, 2007
• 823429 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 Q823429 KB823429 February 21, 2007
• 821103 FIX: The Processing of a Cube That Contains a Virtual Dimension Fails with Error Message: "Object does not exist" Q821103 KB821103 February 21, 2007
• 819248 FIX: An access violation exception may occur when you insert a row in a table that is referenced by indexed views in SQL Server 2000 Q819248 KB819248 February 21, 2007
• 817419 FIX: String Output Parameters Truncated to 4000 Characters with JDBC Q817419 KB817419 February 21, 2007
• 816652 FIX: XMLA Returns Malformed Response if Query Result Contains #ERR in Cells Q816652 KB816652 February 21, 2007
• 815292 FIX: Writeback to Cell Fails If the Cube Contains a Virtual Dimension Q815292 KB815292 February 21, 2007
• 815217 FIX: Inserting Unicode data into SSCE causes SQL Server CE to stop responding or causes an exception error Q815217 KB815217 February 21, 2007
• 815056 FIX: You receive an "Error: 17883" error message when the checkpoint process delays the SQL Server database activity and does not yield the scheduler correctly Q815056 KB815056 February 21, 2007
• 814893 FIX: Error Message: "Insufficient key column information for updating" Occurs in SQL Server 2000 SP3 Q814893 KB814893 February 21, 2007
• 813645 FIX: Improved CPU Usage for Database Logging When Transaction Log Stalls Occur Q813645 KB813645 February 21, 2007
• 813487 FIX: RealTime Cube Performance May Decrease When Update Activity Occurs on the Non-Source SQL Server Database Q813487 KB813487 February 21, 2007
• 813440 A denial of service security issue about the W32.Slammer worm Q813440 KB813440 February 21, 2007
• 331925 FIX: Pre-Analysis Services Service Pack 3 Client Cannot Administer Analysis Services Service Pack 3 Q331925 KB331925 February 21, 2007
• 330058 FIX: Access Violation May Occur When You Use Impersonation and XMLA Connection Pooling Q330058 KB330058 February 21, 2007
• 328878 FIX: Infinite Recursion Detected During Execution of Calculated Member Q328878 KB328878 February 21, 2007
• 327935 FIX: Error Message: "The specified index already exists" May Occur When Re-initializing Subscription with SQL Server CE Edition Q327935 KB327935 February 21, 2007
• 326362 Fix: UDL Dialog for SQL Server OLE DB Provider Generates Empty Server List Q326362 KB326362 February 21, 2007
• 322677 BUG: You Receive an Error Message If the Member Caption Is Different from the Member Name Q322677 KB322677 February 21, 2007
• 320719 FIX: Analysis Services Client Application Memory Usage Grows Each Time You Run a Query Q320719 KB320719 February 21, 2007
• 318582 FIX: Data Mining Messages Are Displayed in English After You Apply Fix Q318582 KB318582 February 21, 2007
• 318375 FIX: SQL Server ODBC Driver Calls iswctype Excessively Causing Slower Performance Q318375 KB318375 February 21, 2007
• 317265 FIX: Real-Time Cube Unable to Re-Establish SQL Server Connection After Network Errors Occur Q317265 KB317265 February 21, 2007
• 316335 FIX: Analysis Service Uses Large Amounts of Client Memory for Queries Q316335 KB316335 February 21, 2007
• 312876 FILE: Ptssetup.exe Sample Automatically Downloads and Installs OLAP Client Q312876 KB312876 February 21, 2007
• 311310 BUG: Analysis Manager Does Not Support HTTP or HTTPS Connections Q311310 KB311310 February 21, 2007
• 311145 BUG: Update of Column That is Part of an Indexed View May Cause a Handled Access Violation Q311145 KB311145 February 21, 2007
• 310624 BUG: DBCC DBREINDEX on Indexed View May Cause Handled Access Violation Q310624 KB310624 February 21, 2007
• 308972 FIX: Drill Down on a Dimension Causes Analysis Manager to Stop Responding (hang) Q308972 KB308972 February 21, 2007
• 308969 FIX: Writeback from OLAP 7.0 Client to Analysis Services Cube Results in Error Message Q308969 KB308969 February 21, 2007
• 308961 FIX: DTS Data Mining Task May Return Syntax Error for Correct Prediction Query Q308961 KB308961 February 21, 2007
• 308956 FIX: A Full Process Fails When a Very Large Dimension Slices a Partition Q308956 KB308956 February 21, 2007
• 306408 INF: Use of Multiple Hierarchies Versus the Creation of Separate Hierarchies Q306408 KB306408 February 21, 2007
• 306191 PRB: Drillthrough Queries Return More Rows than Expected If Cube Schema Is Optimized Q306191 KB306191 February 21, 2007
• 306039 PRB: Long Running OLAP Queries do not Return Data When Connected Through HTTP Q306039 KB306039 February 21, 2007
• 304957 BUG: Analysis Manager May Fail To Connect After Migration of Repository Q304957 KB304957 February 21, 2007
• 304386 INF: MDX: How to Query for the 10 Best Customers and the Top 5 Products for Each Customer Q304386 KB304386 February 21, 2007
• 304341 INF: How to Create a Derived Measure Instead of a Calculated Member Q304341 KB304341 February 21, 2007
• 304213 INF: Different Kinds of Analysis Services Timeouts Q304213 KB304213 February 21, 2007
• 304072 FIX: Synchronization May Fail After You Use Large Text or Image Data Q304072 KB304072 February 21, 2007
• 301934 INF: MDX: How to Determine the First or Last Member with Data Q301934 KB301934 February 21, 2007
• 301909 INF: How to Overcome the 32 KB Limit for SQL Expressions Q301909 KB301909 February 21, 2007
• 301334 PRB: Connection Timeout Occurs When Connecting to a Remote OLAP Server Using an ADO Connection Q301334 KB301334 February 21, 2007
• 297728 FIX: Unhandled Exception Error Querying with the Data Mining Provider from ADO+ and C# Q297728 KB297728 February 21, 2007
• 281460 OSE: Error Messages When You Install Office Server Extensions on Computer with SQL Server 2000 Q281460 KB281460 February 21, 2007
• 281117 FIX: Timeout Error Occurs with Large Dimensions in Dimension Editor or Wizard Q281117 KB281117 February 21, 2007
• 163449 Use of Thread Local Storage in an extended stored procedure Q163449 KB163449 February 21, 2007
• 162294 How to schedule SQL Server backup or DBCC commands by using AT scheduler command Q162294 KB162294 February 21, 2007
• 814084 How to Install SQL Server 2000 SP3 or Security Patch MS02-061 with Content Management Server Q814084 KB814084 February 20, 2007
• 328873 FIX: Query Performance Deteriorates After an Incremental Update to a Non-Changing Dimension Q328873 KB328873 February 20, 2007
• 328721 PRB: Analysis Services Properties are Empty or Set to Zero Q328721 KB328721 February 20, 2007
• 327572 PRB: You Cannot Change the Data Source for a PivotTable in Excel for an Analysis Services Connection Q327572 KB327572 February 20, 2007
• 327170 FIX: Archive of Analysis Services Database Fails with Overflow and CabArc.exe Failed Errors Q327170 KB327170 February 20, 2007
• 326559 FIX: SSCE Replication Client Agent Stops Responding with Merge of Large Text or Image Q326559 KB326559 February 20, 2007
• 324978 FIX: A Drillthrough on a Virtual Cube Returns an Empty Set Q324978 KB324978 February 20, 2007
• 324905 FIX: OLAP Calculated Member That References Distinct Count Calculated Member Returns 0 Q324905 KB324905 February 20, 2007
• 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 February 20, 2007
• 322911 FIX: Out of Memory or Significant Delay Occurs When You Expand a Cube or Edit a Dimension in Analysis Manager Q322911 KB322911 February 20, 2007
• 322325 INF: Performance Study of Microsoft Data Mining Algorithms (White Paper) Q322325 KB322325 February 20, 2007
• 320407 FIX: SQLMail Extended Stored Procedures May Fail with an Access Violation on SQL Server 2000 SP2 when SQL Server is Run As a Windows NT Service Q320407 KB320407 February 20, 2007
• 317486 FIX: A Query That Uses a Large Search String in the CONTAINS Clause May Fail with Error Message 7607 Q317486 KB317486 February 20, 2007
• 317258 PRB: Member Key Column for Parent-Child Dimensions Must Be Unique Q317258 KB317258 February 20, 2007
• 317161 FIX: .NET MDX Queries Fail When You Use the OleDbDataAdapter or OleDbDataReader Classes Q317161 KB317161 February 20, 2007
• 316295 FIX: MDX Queries from Query Analyzer to a Linked Analysis Server Result in Fatal Exception Q316295 KB316295 February 20, 2007
• 316285 FIX: Unexpected Internal Error Occurs When You Query a Virtual Cube with Calculated Measures Q316285 KB316285 February 20, 2007
• 313597 BUG: Analysis Services Performance Counters Disappear after You Install Service Pack 2 Q313597 KB313597 February 20, 2007
• 311873 FIX: Analysis Manager Disappears When You Save a Role or Validate Security During Restore Q311873 KB311873 February 20, 2007
• 311863 BUG: Internal Error Occurs When You Run a MDX Query with a NON EMPTY Clause Against a Virtual Cube Q311863 KB311863 February 20, 2007
• 311528 BUG: Infinite Recursion Error with Parent-Child Dimension and Custom Member Q311528 KB311528 February 20, 2007
• 309385 FIX: Incorrect Result Occurs with Unary Operator When You Execute Query on the Server Q309385 KB309385 February 20, 2007
• 309093 FIX: Buffer Latch Timeouts or Server Sluggishness Occurs When You Remove Procedures From Cache Q309093 KB309093 February 20, 2007
• 308973 FIX: MDX Lag() Function Returns Incorrect Results Intermittently Q308973 KB308973 February 20, 2007
• 308966 FIX: Use of MDX Hierarchize Function Over a CrossJoin Set Fails with Internal Error Q308966 KB308966 February 20, 2007
• 308963 FIX: Data Types for Some Columns in MINING_SERVICES Schema Rowset are not Compliant with the OLE DB Data Mining Specifications Q308963 KB308963 February 20, 2007
• 308962 FIX: ROLAP Storage on Oracle Does Not Create Indexes for Aggregation Tables Q308962 KB308962 February 20, 2007
• 308955 FIX: Incorrect Results Occur with Write Back of Different Data Types Q308955 KB308955 February 20, 2007
• 307945 INF: How to Carry Balances Forward for Display in a Balance Sheet. Q307945 KB307945 February 20, 2007
• 307276 INF: How to Use the Linear Regression Functions Q307276 KB307276 February 20, 2007
• 307008 INF: How to Check for 64 K Children Before You Process a Dimension Q307008 KB307008 February 20, 2007
• 306990 INF: When to Create a Virtual Dimension Instead of a Physical Dimension Q306990 KB306990 February 20, 2007
• 305137 FIX: Error "Unable to retrieve children: Member with the UniqueName not found" Q305137 KB305137 February 20, 2007
• 304337 INF: How to Control a Member's Unique Name Q304337 KB304337 February 20, 2007
• 304155 INF: Advantages of Using Numeric Dimension Keys Q304155 KB304155 February 20, 2007
• 304137 INF: How to Increase the Speed of MDX Queries that Contain the NON EMPTY Keyword Q304137 KB304137 February 20, 2007
• 303969 INF: How to Work with More Than 64,000 Children Per Parent Q303969 KB303969 February 20, 2007
• 303408 INF: The Impact of Using Changing Dimensions Q303408 KB303408 February 20, 2007
• 301637 INF: How to Calculate the Cumulative Value of a Measure Q301637 KB301637 February 20, 2007
• 296267 FIX: Analysis Services Cubes Using Unisys DMS II Database Report ODBC Error Q296267 KB296267 February 20, 2007
• 296186 FIX: Incorrect Results In Cube Editor When You Edit a Dependent Calculated Member or Calculated Cell Q296186 KB296186 February 20, 2007
• 326827 FIX: Calculated Member Causes Formatting of All Measures to Match First Measure Q326827 KB326827 February 19, 2007
• 323039 FIX: Full-Text Search Population of a Word Document Stored in SQL Server Causes CPU Spin with SQL Server 2000 Service Pack 2 Q323039 KB323039 February 19, 2007
• 321719 FIX: Zeros Returned Incorrectly from OLAP Data Source with Calculated Measures Q321719 KB321719 February 19, 2007
• 320736 FIX: Writeback Fails with "Relational data provider reported error: []." Error Message Q320736 KB320736 February 19, 2007
• 320710 FIX: Error Message "Unable to open cellset. Cannot connect to server" Occurs When a Query is Sent to Analysis Services Q320710 KB320710 February 19, 2007
• 319636 BUG: Date Formats Change to DBTimeStamp After Server Processes Cube Q319636 KB319636 February 19, 2007
• 311880 FIX: MDSCHEMA_DIMENSIONS Returns Incorrect Value for DIMENSION_MASTER_UNIQUE_NAME Q311880 KB311880 February 19, 2007
• 310714 BUG: DBCC DBREINDEX Can Cause Error 8623 on Indexed View Q310714 KB310714 February 19, 2007
• 307748 PRB: Duplicate Rows in Dimension Tables Inflate Measures Q307748 KB307748 February 19, 2007
• 303438 PRB: Unable to See All Cubes When Connecting from Excel 2000 to Analysis Services Q303438 KB303438 February 19, 2007
• 296533 INF: Analysis Services Processing Task May Not Execute Correctly Q296533 KB296533 February 19, 2007
• 244650 INF: Working with NULL Values in OLAP Services Q244650 KB244650 February 19, 2007
• 62866 Description of the reasons that the SQL Server transaction log is not being truncated Q62866 KB62866 February 19, 2007
• 819261 BUG: Error 15023, 15024 or 21002 Occurs When You Try to Add a Domain User or a Domain Group to the Database Q819261 KB819261 February 16, 2007
• 818763 FIX: Intense SQL Server Activity Results in Spinloop Wait in SQL Server 2000 Service Pack 2 Q818763 KB818763 February 16, 2007
• 306212 How to troubleshoot error 7391 that occurs when you use a linked server in SQL Server Q306212 KB306212 February 16, 2007
• 229564 SQL application role errors with OLE DB resource pooling Q229564 KB229564 February 15, 2007
• 908156 FIX: You receive an error message when MS DTC for SQL Server 2000 reuses a server process identifier (SPID) to enlist in a distributed transaction Q908156 KB908156 February 14, 2007
• 905765 FIX: A view is corrupted after you run the DBCC DBREINDEX Transact-SQL statement to rebuild the clustered index on a view in SQL Server 2000 Q905765 KB905765 February 14, 2007
• 899580 The Full Text resource fails when you install a new clustered instance after you apply SQL Server 2000 Service Pack 4 to an existing clustered instance Q899580 KB899580 February 14, 2007
• 892517 FIX: A drillthrough operation fails, and you may receive an "Unable to drill through" error message after you configure drillthrough permissions on a virtual cube in SQL Server 2000 Analysis Services Q892517 KB892517 February 14, 2007
• 889521 FIX: Synchronization of a merge publication that uses the "Subscriber Always Wins Conflict Resolver" conflict resolver is unsuccessful in SQL Server 2000 Windows CE Edition 2.0 Q889521 KB889521 February 14, 2007
• 885435 FIX: The DSO Process(ProcessSuspendLazyProcessing) method does not suspend the lazy processing of aggregations on a remote partition in SQL Server 2000 Analysis Services Q885435 KB885435 February 14, 2007
• 885286 FIX: The Reporting Services trace log file size may increase unexpectedly Q885286 KB885286 February 13, 2007
• 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 February 13, 2007
• 872935 FIX: A lazy aggregation operation on one or more partitions may fail and you may notice an "Error during lazy aggregation of partition <Partition name> in cube <Cube name>" error message in the application event log Q872935 KB872935 February 13, 2007
• 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 February 13, 2007
• 836136 FIX: The compile time for a query that uses at least one outer join may be greater for SQL Server post-SP3 builds Q836136 KB836136 February 12, 2007
• 827898 FIX: Specify the Analysis Services Client Locale on the Connection String Q827898 KB827898 February 12, 2007
• 330014 How to upgrade an Internet Information Services server after applying SQL Server 2000 Service Pack 3 or SQL Server 2000 Service Pack SP3a Q330014 KB330014 February 12, 2007
• 325808 SQL Server 2000 Windows CE Edition component releases and versions Q325808 KB325808 February 12, 2007
• 322074 INF: International Considerations in Applications Developed for SQL Server 2000 Windows CE Edition Q322074 KB322074 February 12, 2007
• 317341 Error occurs on RDA.LocalConnectionString when you use a large string Q317341 KB317341 February 12, 2007
• 317268 PRB: The MSDE Installation Does Not Succeed If the Installation Computer Is Running Terminal Services in Application Server Mode Q317268 KB317268 February 12, 2007
• 315889 FIX: Insertion of NULL Values into NTEXT Columns May Cause Application Instability Q315889 KB315889 February 12, 2007
• 313153 Windows NT account lockout with SQL Server CE Replication and invalid password Q313153 KB313153 February 12, 2007
• 307530 FIX: SQL Server CE OLE DB Provider Specific Properties Give Compilation Error Q307530 KB307530 February 12, 2007
• 306452 FIX: SQL Server CE eMbedded Visual Basic CompactDatabase Unable to Fix Corrupted Database Q306452 KB306452 February 12, 2007
• 300597 BUG: NOT FOR REPLICATION clause causes SQL Server CE replication to fail Q300597 KB300597 February 12, 2007
• 285854 PRB: Application Error Occurs When You Run Two Instances of Replication or RDA Application on HPC Pro Devices Q285854 KB285854 February 12, 2007
• 280459 BUG: SQL Server CE Filtered Recordset Permits Navigation Outside Filter Q280459 KB280459 February 12, 2007
• 257767 PRB: Cannot Open Pubs Table Image Data Through Microsoft Access Link Q257767 KB257767 February 12, 2007
• 243053 How to create an application role on SQL Server 2000 from within Visual FoxPro Q243053 KB243053 February 12, 2007
• 321190 SQL Server cluster supportability with MCMS 2002 and with MCMS 2001 Q321190 KB321190 February 10, 2007
• 830775 BUG: The Server Network Utility dialog box does not open when you try to open the utility by using SQL Server Enterprise Manager Q830775 KB830775 February 8, 2007
• 818847 How to troubleshoot customer issues by using Analysis Manager and OLAP Q818847 KB818847 February 5, 2007
• 906508 BUG: You receive a "System.Data.SqlClient.SqlException" error message when you run the Data Extraction Program tool (Rpdataextraction.exe) Q906508 KB906508 February 2, 2007
• 329506 You receive an error message when you try to log on to Microsoft Project Web Access or when you try to create a document in Microsoft Project Professional 2002 Q329506 KB329506 February 1, 2007
• 326839 Support WebCast: Microsoft SQL Server: How to Configure, Manage, Use, and Troubleshoot Linked Servers Q326839 KB326839 February 1, 2007