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.

• 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
• 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
• 308264 BUG: SQLDescribeCol Returns Wrong Column Size in a Complex Union Query with Parameters Q308264 KB308264 February 23, 2007
• 306266 FIX: Updates to Distributed Partitioned Views May Return Incorrect @@ROWCOUNT Value Q306266 KB306266 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
• 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
• 328876 FIX: Analysis Services Cannot Start and You Receive This Error Message: "MSSQLServerOLAPService service terminated unexpectedly" Q328876 KB328876 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
• 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
• 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
• 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
• 322095 INF: Using Partitions in a SQL Server 2000 Data Warehouse (White Paper) Q322095 KB322095 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
• 318122 INFO: Using Analysis Server Format Properties with the Office XP PivotTable Component Q318122 KB318122 February 22, 2007
• 314570 PRB: Cannot Modify Backup Network Share After You Change the Transaction Log Backup Folder Q314570 KB314570 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
• 313352 FIX: "Numeric Value Out Of Range" Error Message When You Execute Batch SQL Statements Q313352 KB313352 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
• 310654 IIS Lock Down Tool may break RDA or Replication that uses Anonymous authentication Q310654 KB310654 February 22, 2007
• 307365 PRB: Cannot Connect Through Analysis Manager Although a Member of Administrator Group Q307365 KB307365 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
• 303415 INF: File Size Limitations For Use of Archive/Restore for OLAP Q303415 KB303415 February 22, 2007
• 303228 FIX: Queue Reader Agent Fails if the Distributor is a Clustered SQL Server Q303228 KB303228 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 286280 Description of the effect to database recovery after you add or remove database files Q286280 KB286280 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
• 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
• 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
• 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
• 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
• 231951 INF: Permissions That You Must Have to Administer an OLAP Server Q231951 KB231951 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
• 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
• 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
• 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
• 318375 FIX: SQL Server ODBC Driver Calls iswctype Excessively Causing Slower Performance Q318375 KB318375 February 21, 2007
• 312876 FILE: Ptssetup.exe Sample Automatically Downloads and Installs OLAP Client Q312876 KB312876 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
• 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
• 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
• 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
• 327572 PRB: You Cannot Change the Data Source for a PivotTable in Excel for an Analysis Services Connection Q327572 KB327572 February 20, 2007
• 317161 FIX: .NET MDX Queries Fail When You Use the OleDbDataAdapter or OleDbDataReader Classes Q317161 KB317161 February 20, 2007
• 313597 BUG: Analysis Services Performance Counters Disappear after You Install Service Pack 2 Q313597 KB313597 February 20, 2007
• 309093 FIX: Buffer Latch Timeouts or Server Sluggishness Occurs When You Remove Procedures From Cache Q309093 KB309093 February 20, 2007
• 307276 INF: How to Use the Linear Regression Functions Q307276 KB307276 February 20, 2007
• 305137 FIX: Error "Unable to retrieve children: Member with the UniqueName not found" Q305137 KB305137 February 20, 2007
• 304155 INF: Advantages of Using Numeric Dimension Keys Q304155 KB304155 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
• 321719 FIX: Zeros Returned Incorrectly from OLAP Data Source with Calculated Measures Q321719 KB321719 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
• 229564 SQL application role errors with OLE DB resource pooling Q229564 KB229564 February 15, 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
• 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
• 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
• 325808 SQL Server 2000 Windows CE Edition component releases and versions Q325808 KB325808 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
• 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
• 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
• 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
• 326839 Support WebCast&#58; Microsoft SQL Server&#58; How to Configure, Manage, Use, and Troubleshoot Linked Servers Q326839 KB326839 February 1, 2007