SQL Server 2000 articles, fixes and updates

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2000 starts with letter I that have been released. The list is daily updated.

234656 Information about using disk drive caches with SQL Server that every database administrator should know Q234656 KB234656 January 25, 2021
316626 INF: How SQL Server Compares Strings with Trailing Spaces Q316626 KB316626 August 20, 2020
810826 INF: New Switches in MSDE Service Pack 3 Setup Q810826 KB810826 April 23, 2018
301934 INF: MDX: How to Determine the First or Last Member with Data Q301934 KB301934 April 20, 2018
301901 INF: TCP Ports Used by OLAP Services when Connecting Through a Firewall Q301901 KB301901 April 20, 2018
301637 INF: How to Calculate the Cumulative Value of a Measure Q301637 KB301637 April 20, 2018
298402 INF: Understanding How to Set the SQL Server I/O Affinity Option Q298402 KB298402 April 20, 2018
295108 Incomplete transaction may hold large number of locks and cause blocking Q295108 KB295108 April 20, 2018
321081 Installation of MSDE creates an 'sa' account with a blank password in Visio Q321081 KB321081 April 19, 2018
305977 INF: Frequently Asked Questions - SQL Server 2000 - Table Variables Q305977 KB305977 April 19, 2018
290212 INF: List of Bugs Fixed in SQL Server 2000 Service Pack 1 (1 of 2) Q290212 KB290212 April 19, 2018
272318 INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE Q272318 KB272318 April 19, 2018
815431 Installation of a named instance of SQL Server 2000 virtual server on a Windows Server 2003-based cluster fails Q815431 KB815431 April 13, 2018
224453 INF: Understanding and resolving SQL Server blocking problems Q224453 KB224453 October 23, 2017
911845 It takes a long time for the SQL Server service to start on a Windows Server 2003-based computer Q911845 KB911845 January 17, 2015
318610 INF: Data Types to Use for Currency Conversion Between European Nations Q318610 KB318610 January 17, 2015
317862 INF: Workaround for Changing the File Path of a Report in SQL Web Publishing Q317862 KB317862 January 17, 2015
301456 INF: How to Use OLAP Number Formats with Office Web Components Q301456 KB301456 January 17, 2015
306625 INF: Last Batch Date is Seen as 1900-01-01 00:00:00.000 Q306625 KB306625 January 16, 2015
285165 INF: Attaching or Restoring a SQL Server 7.0 Database To SQL Server 2000 Does Not Change the Compatibility Mode Q285165 KB285165 January 16, 2015
269487 INF: SQL Server Service Manager Does Not Immediately Indicate Service Status Q269487 KB269487 January 16, 2015
263872 INF: Restrictions for Use of the Fraction Field of a TIMESTAMP_STRUCT with SQL Server Q263872 KB263872 January 16, 2015
246333 INF: SQL Server Data Transformation Services and the Microsoft Repository Q246333 KB246333 January 16, 2015
229888 INF: Subquery Column Can Be Resolved as Outer Query Column Q229888 KB229888 January 16, 2015
199834 INF: SQL Server Support for the Euro Currency Symbol Q199834 KB199834 January 16, 2015
269074 INF: How to Run a DTS Package as a Scheduled Job Q269074 KB269074 June 22, 2014
263556 INF: How to Configure SQL Mail Q263556 KB263556 June 22, 2014
279489 INF: How to Connect to Analysis Server 2000 By Using HTTP Connection Q279489 KB279489 June 19, 2014
820909 INFO: SQL Server Net-Libraries Support for the QLogic Card Q820909 KB820909 February 27, 2014
815430 INF: How to Suppress the Appshelp Message in an Unattended Installation Q815430 KB815430 February 27, 2014
814618 INF: How to Determine the Download Files You Need for Upgrading to SQL Server 2000 Service Pack 3 Q814618 KB814618 February 27, 2014
814399 INF: Encrypted Password Is Not Supported in Intialization File for Installing SQL Server 2000 Service Pack 3 (SP3) Q814399 KB814399 February 27, 2014
813849 INF: Enabling Cross-Database Ownership Chaining for Notification Services Databases Q813849 KB813849 February 27, 2014
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 2, 2013
822339 INF: Enhancements to SQL Server 2000 Notification Services Service Packs Q822339 KB822339 November 2, 2013
822215 INF: The versions of Teradata that are supported by Analysis Services Q822215 KB822215 November 2, 2013
814461 INF: SQL Server 2000 SQL Check Utility Q814461 KB814461 November 2, 2013
322596 INF: Creating Large-Scale, Highly Available OLAP Sites (White Paper) Q322596 KB322596 November 2, 2013
322325 INF: Performance Study of Microsoft Data Mining Algorithms (White Paper) Q322325 KB322325 November 2, 2013
322320 INF: SQL Server CE Relay Q322320 KB322320 November 2, 2013
322226 INF: XML for Analysis Specification (White Paper) Q322226 KB322226 November 2, 2013
322074 INF: International Considerations in Applications Developed for SQL Server 2000 Windows CE Edition Q322074 KB322074 November 2, 2013
317620 INF: You Are Prompted for File Location During MSDE 2.0 SP2 Setup Q317620 KB317620 November 2, 2013
316497 INF: List of Bugs Fixed by SQL Server 2000 Windows CE Edition 1.1 Service Packs Q316497 KB316497 November 2, 2013
314309 INF: SQL Server 2000 Service Pack 1 and Service Pack 2 Fixlist for SQL Mail Q314309 KB314309 November 2, 2013
295748 INFO: SQL Server CE Bits for CEPC Installed Only if Platform Builder 3.0 is Installed Q295748 KB295748 November 2, 2013
271592 INFO: Cannot Create a SQL Server CE Database on Connection.Execute Q271592 KB271592 November 2, 2013
270896 INFO: SQL Server CE Query Analyzer Does Not Display Descriptive Data Type Q270896 KB270896 November 2, 2013
271931 INFO: Using Multiple Recordsets for Performance with SQL Server CE Database Q271931 KB271931 November 1, 2013
316901 INF: SQL Server 2000 Windows CE Edition Version 1.1 Service Pack 1 Readmesp1.txt Addition Q316901 KB316901 October 26, 2013
304337 INF: How to Control a Member's Unique Name Q304337 KB304337 October 26, 2013
304137 INF: How to Increase the Speed of MDX Queries that Contain the NON EMPTY Keyword Q304137 KB304137 October 26, 2013
303969 INF: How to Work with More Than 64,000 Children Per Parent Q303969 KB303969 October 26, 2013
295027 INF: Limited Support for Savepoint in Distributed Transactions in SQL Server 2000 Service Pack 1 Q295027 KB295027 October 26, 2013
293815 INF: Dimension Rules for Security Role Not Saved When Programmatically Set Q293815 KB293815 October 26, 2013
316426 INF: SQL Server 2000 Security Update for Service Pack 1 Q316426 KB316426 October 24, 2013
307945 INF: How to Carry Balances Forward for Display in a Balance Sheet. Q307945 KB307945 October 24, 2013
307008 INF: How to Check for 64 K Children Before You Process a Dimension Q307008 KB307008 October 24, 2013
306990 INF: When to Create a Virtual Dimension Instead of a Physical Dimension Q306990 KB306990 October 24, 2013
306909 INF: SQL Server 2000 Service Pack 2 Readme.txt Additions Q306909 KB306909 October 24, 2013
306408 INF: Use of Multiple Hierarchies Versus the Creation of Separate Hierarchies Q306408 KB306408 October 24, 2013
303408 INF: The Impact of Using Changing Dimensions Q303408 KB303408 October 24, 2013
300538 INF: List of Bugs Fixed in SQL Server 2000 Service Pack 1 (2 of 2) Q300538 KB300538 October 24, 2013
299926 INF: Writebacks That Use Multi-Hierarchies Must Specify All Hierarchies Q299926 KB299926 October 23, 2013
274199 INF: Cannot Install MSDE 2000 on Windows 95 Q274199 KB274199 October 21, 2013
255596 INF: sp_lock2 Returns Additional Locking Details Q255596 KB255596 March 20, 2013
274348 INF: Distributed Queries Executed Within a Trigger Enlist MSDTC Q274348 KB274348 March 8, 2013
315721 INF: Can Only Apply SQL Server 2000 Desktop Engine Service Pack 2 Download on the Internet to Instances Installed from Sqlrun01.msi Q315721 KB315721 January 21, 2013
238912 INF: Understanding Microsoft Repository Q238912 KB238912 December 11, 2012
261334 INF: Frequently Asked Questions - SQL Server 2000 - Upgrade Q261334 KB261334 November 9, 2012
299795 INF: How to Author MSDE 2000 Setup Packages with Microsoft Visual Studio Installer 1.1 Q299795 KB299795 September 3, 2012
243218 Installation order for SQL Server 2000 Enterprise edition on Microsoft Cluster Server Q243218 KB243218 August 7, 2012
229929 INFO: Registry Entries and Keywords for SQL Server Connection Strings Q229929 KB229929 April 20, 2012
315886 INF: Common SQL Mail Problems Q315886 KB315886 March 30, 2012
228940 INF: VB .DEP Files Not Available for SQL Server Redistributable Components Q228940 KB228940 September 17, 2011
967094 ISA Server 2004 and ISA Server 2006 may be affected by the security updates in Microsoft Knowledge Base articles 960082 and 960083 Q967094 KB967094 May 14, 2009
955495 Incorrect characters appear in a SQL Server Reporting Services report after you export it to a PDF file Q955495 KB955495 March 19, 2009
819947 Interface of Tables and Views in EM become RTL after installing SP1 for SQL Server 2000 Q819947 KB819947 August 25, 2008
819334 INF: SQL Server 2000 Service Pack 3a Synopsis Q819334 KB819334 November 26, 2007
814852 INF: How to Enable Encryption Support for SQL Server CE Databases Q814852 KB814852 November 14, 2007
891984 Implications of removing the xp_cmdshell stored procedure from SQL Server 2000 Q891984 KB891984 November 2, 2007
810474 INF: Cross-Database Ownership Chaining Behavior Changes in SQL Server 2000 Service Pack 3 Q810474 KB810474 October 29, 2007
330244 INF: How to Restore the Repository Connection String to the Correct Format After You Remove Analysis Services Service Pack 3 or Service Pack 3a Q330244 KB330244 October 29, 2007
330022 INF: SQL Server 2000 Service Pack 3 Readme.htm Additions Q330022 KB330022 October 29, 2007
327957 INF: SQL Server 2000 Windows CE Edition Version 2.0 Readme.txt Additions Q327957 KB327957 October 29, 2007
327217 INF: Installing SQL Server 2000 Service Pack 3 Rebuilds All Full-Text Catalogs Q327217 KB327217 October 29, 2007
307775 INF: Disaster Recovery Articles for Microsoft SQL Server Q307775 KB307775 October 29, 2007
299641 INF: Understanding How to Configure a SQL Server Connection Affinity Mask Q299641 KB299641 October 26, 2007
295443 INF: How To Enable Analysis Server to Use 3 GB of RAM Q295443 KB295443 October 26, 2007
322742 INFO: Content Management Server Supports SQL Server Log Shipping for Failover Q322742 KB322742 May 23, 2007
828089 INFO: Migrating from Microsoft Office XP Developer Q828089 KB828089 May 18, 2007
833559 In SQL Server 2000, a domain user cannot run the xp_cmdshell extended stored procedure even when the user has permissions Q833559 KB833559 April 29, 2007
325023 INFO: Upsize SQL Server 2000 Desktop Engine to SQL Server Q325023 KB325023 April 28, 2007
883724 Information about the SQL Server edition of the MPS Reporting tool Q883724 KB883724 April 10, 2007
266650 Information About BackOffice Program Support on Windows 2000 Datacenter Server-Based Computers Q266650 KB266650 March 1, 2007
816824 INF: SQL Server 2000 Evaluation Edition Release A Q816824 KB816824 February 22, 2007
322966 INF: Visual Basic for Applications and Excel Library Functions Are Not listed in MDX Builder Q322966 KB322966 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
318122 INFO: Using Analysis Server Format Properties with the Office XP PivotTable Component Q318122 KB318122 February 22, 2007
310654 IIS Lock Down Tool may break RDA or Replication that uses Anonymous authentication Q310654 KB310654 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
302341 INF: New Trace Flag to Enable Singleton Update for Transactional Replication Q302341 KB302341 February 22, 2007
294287 INF: How to Automate an Archive or Backup of OLAP Database Q294287 KB294287 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
272210 INFO: System Tables in SQL Server CE Database Q272210 KB272210 February 22, 2007
269662 INF: SQL Server 2000 Books Online Information on Distributed Partitioned Views Q269662 KB269662 February 22, 2007
231951 INF: Permissions That You Must Have to Administer an OLAP Server Q231951 KB231951 February 22, 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
307276 INF: How to Use the Linear Regression Functions Q307276 KB307276 February 20, 2007
304155 INF: Advantages of Using Numeric Dimension Keys Q304155 KB304155 February 20, 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
829024 INFO: Microsoft SQL Server 2000 Operations Guide Q829024 KB829024 January 19, 2007
324040 INF: Connect to Analysis Services By Using "SSPI = Anonymous" on Windows XP Q324040 KB324040 November 21, 2006
299905 INF: Data Types Used by Analysis Services Q299905 KB299905 November 21, 2006
328446 INF: How to Set Up Watson Error Reporting on SQL Server 2000 Service Pack 3 Servers Q328446 KB328446 October 10, 2006
310650 INFO: Known Issues with the Visual Basic T-SQL Debugger and SQL Server 2000 Q310650 KB310650 September 29, 2006
311115 INF: Correction for Microsoft SQL Server 2000 Resource Kit Q311115 KB311115 September 14, 2006
324411 INF: Available White Papers for SQL Server Q324411 KB324411 September 13, 2006
160181 INFO: Trace Flag to Replicate UPDATE as DELETE/INSERT Pair Q160181 KB160181 September 1, 2006
322620 INF: How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000 (White Paper) Q322620 KB322620 July 27, 2006
279153 INF: Upgrade Wizard Does Not Transfer Existing Stored Procedures Q279153 KB279153 July 27, 2006
323411 INF: Programs Run Through Xp_cmdshell Have No User Interface Q323411 KB323411 June 22, 2006
188883 INF: How to Install Only the SQL Server Books Online Q188883 KB188883 May 5, 2006
280101 INF: Transact-SQL Debugger Limitations and Troubleshooting Tips for SQL Server 2000 Q280101 KB280101 November 30, 2005
823545 Insert or update operations that are not correct occur when you synchronize a SQL Server CE subscriber with a publisher Q823545 KB823545 September 9, 2005
322615 INF: Exposing SQL Server Data to the Web with XML (White Paper) Q322615 KB322615 July 11, 2005
221592 INF: Err Msg "Cannot Obtain Server's Start Directory From Registry" Q221592 KB221592 June 23, 2005
152174 INF: Output Parameters, Return Codes and the ODBC Driver Q152174 KB152174 March 16, 2005
184039 INFO: Using Return Codes with xp_cmdshell Stored Procedure Q184039 KB184039 March 14, 2005
176480 INF: How to Restrict the Inner Table of an ANSI Outer Join Q176480 KB176480 March 14, 2005
176426 INF: How to Determine the Number of Rows of Every Table in a Database Q176426 KB176426 March 14, 2005
175955 INF: How to Write a Variance Query in SQL Server Q175955 KB175955 March 14, 2005
175850 INF: How to Create Dynamic Table Names in SQL Server Q175850 KB175850 March 14, 2005
156501 INF: QUOTED_IDENTIFIER and Strings with Single Quotation Marks Q156501 KB156501 March 14, 2005
154886 INF: Behavior of ANSI_PADDING Q154886 KB154886 March 14, 2005
154395 INF: Rebuilding the Pubs Database Q154395 KB154395 March 14, 2005
139528 INFO: Table Alias Syntax Checking in SQL 6.0 and Later is ANSI-Compliant Q139528 KB139528 March 14, 2005
44730 INF: Using Windows Global Heap Buffers Q44730 KB44730 March 14, 2005
197247 INF: "OR" Clause Prohibits the Use of Merge or Hash Algorithms Q197247 KB197247 March 2, 2005
48711 INF: Finding Names of Columns that Comprise the Key of a Table Q48711 KB48711 March 2, 2005
45261 INF: No Timestamp Is Returned by dbtsnewval() If Update Fails Q45261 KB45261 March 2, 2005
165951 INF: Result Processing for SQL Server Q165951 KB165951 March 1, 2005
162032 INF: Cannot SELECT DISTINCT * on a Table w/ Text/Image Column Q162032 KB162032 March 1, 2005
159747 INF: Canceled Transaction in a Temp Table Causes X and U Locks Q159747 KB159747 February 22, 2005
131913 INF: Scoping of Temporary Objects with EXEC Q131913 KB131913 February 22, 2005
124015 INFO: Trigger Execute Even if No Rows Affected by SQL Statement Q124015 KB124015 February 22, 2005
109649 INF: dbnextrow Does Not Return Fail on Deadlock Q109649 KB109649 February 22, 2005
107561 INF: Assignment of Empty Results Set Does Not Set Variable Q107561 KB107561 February 22, 2005
171299 INF: How to Obtain Case-Sensitive Query Results with a Case-Insensitive Sort Order Q171299 KB171299 February 14, 2005
158325 INF: Stored Procedures, Transactions, and Error 266 Q158325 KB158325 February 14, 2005
155723 INF: SQL Server Truncation of a DBCS String Q155723 KB155723 February 14, 2005
125627 INF: Starting SQL Server Remotely from the NT Command Prompt Q125627 KB125627 February 14, 2005
98620 INF: BCP and NULL Values Q98620 KB98620 February 14, 2005
90477 INFO: Aggregates and SET Clause in UPDATE Statement Q90477 KB90477 February 14, 2005
79886 INF: Example of Using Nested Triggers Q79886 KB79886 February 14, 2005
76784 INF: Operating System Commands and Control of Flow in ISQL or OSQL Q76784 KB76784 February 14, 2005
68230 INF: Using Substring to Parse & Interpret Binary Data in SQL Q68230 KB68230 February 14, 2005
67659 INFO: BCPing in Just the Date of Datetime Column Q67659 KB67659 February 14, 2005
67410 INFO: Use User-Defined Data Type to Extract Current Time Q67410 KB67410 February 14, 2005
60054 INF: Restoration of a Database from Transaction Dumps Q60054 KB60054 February 14, 2005
47270 INFO: SQL Access Permissions and Trigger Execution Q47270 KB47270 February 14, 2005
39084 INF: Using dbdata() Versus dbbind() Q39084 KB39084 February 14, 2005
297864 INF: Performance Considerations for an Upgrade from SQL Server 6.5 Q297864 KB297864 January 12, 2005
883370 Information about how to obtain the latest SQL Server 2000 Driver for JDBC service pack Q883370 KB883370 September 2, 2004
286124 INF: How to Reschedule a DTS Package Q286124 KB286124 July 15, 2004
199132 INF: OLAP: How to Index Star/Snowflake Schema Data Q199132 KB199132 June 28, 2004
117559 INFO: How to Correlate Spid, Kpid, and Thread Instance Q117559 KB117559 June 14, 2004
285997 Initial snapshot generation may fail if network redirector caching is enabled Q285997 KB285997 May 6, 2004
287093 INFO: DB2OLEDB Supports UPDATE/DELETE from SQL Linked Server Q287093 KB287093 March 26, 2004
272705 INF: Default Data and Log Directory Display Blank by Default After You Install SQL Server 2000 Q272705 KB272705 March 18, 2004
315642 INF: Information that PSS needs to troubleshoot SQL Server replication Q315642 KB315642 March 2, 2004
322718 INF: PeopleSoft Financials Online - Benchmark (White Paper) Q322718 KB322718 March 1, 2004
196911 INF: Database Creation and Backup Operations Use Parallelism Q196911 KB196911 February 23, 2004
322866 INF: RDBMS performance tuning guide for data warehousing (white paper) Q322866 KB322866 February 11, 2004
272424 INF: Object Ownership Chain Checking Across Databases Depends on the Login That Is Mapped to the Object Owners Q272424 KB272424 February 5, 2004
322072 INF: Microsoft SQL Server MegaServers: Achieving Software Scale-Out (White Paper) Q322072 KB322072 January 15, 2004
199294 INF: Server Side Cursor Behavior When CURSOR_CLOSE_ON_COMMIT Set OFF Q199294 KB199294 December 5, 2003
143337 INF: Behavior if Both ARITHABORT & ARITHIGNORE Are Set ON Q143337 KB143337 December 5, 2003
322333 INF: C#: A SQL Server XML and ASP.NET Run-time Application (White Paper) Q322333 KB322333 December 3, 2003
151596 INF: Extended Procedure Error: "Cannot find the DLL 'xxx.dll'" Q151596 KB151596 December 3, 2003
140696 INF: RAISERROR, PRINT, and the MS SQL Server ODBC Driver Q140696 KB140696 December 3, 2003
139555 INF: Invalid Use of dbwritetext Can Cause 806 Errors Q139555 KB139555 December 3, 2003
44415 INF: Timestamps and Their Uses Q44415 KB44415 December 3, 2003
240025 INF: Rollback Transaction in Triggers at Subscriber Can Break Transactional Integrity Q240025 KB240025 November 26, 2003
268877 INF: Registering SQL Server Wizard Gives a Misleading Error Message Q268877 KB268877 November 14, 2003
268784 INF: SQL Enterprise Manager Rounds Database Size Q268784 KB268784 November 14, 2003
257434 INF: Network Library in Existing DSN Replaced by Network Library in New DSN to the Same SQL Server Name Q257434 KB257434 November 14, 2003
174817 INF: Microsoft SQL Server DB-Library Has Limited Extensibility Q174817 KB174817 November 14, 2003
271624 INF: Using DBCC MEMORYSTATUS to Monitor SQL Server Memory Usage Q271624 KB271624 November 12, 2003
291001 INF: How to Use sp_scriptdynamicupdproc to Improve the Performance of Update Custom Procedures in SQL Server 2000 Transactional Replication Q291001 KB291001 November 6, 2003
283790 INF: How to Create a SQL Server 2000 Trace Q283790 KB283790 November 6, 2003
268251 INF: How to Identify Multiple Instances of SQL 2000 When You Use Performance Monitor Q268251 KB268251 November 6, 2003
322910 INF: Managed Range Identities in Merge Replication Q322910 KB322910 November 5, 2003
283786 INF: How to Monitor SQL Server 2000 Traces Q283786 KB283786 November 5, 2003
283784 INF: How to View SQL Server 2000 Activity Data Q283784 KB283784 November 5, 2003
283725 INF: How to View SQL Server 2000 Blocking Data Q283725 KB283725 November 5, 2003
281671 INF: Stored Procedure to Create a SQL Server 2000 Blackbox Trace Q281671 KB281671 November 5, 2003
180779 INF: Proper Use for DB-Library Err Handler Return Code INT_EXIT Q180779 KB180779 November 5, 2003
222657 INF: Storing a Directory Tree and Maintaining a Full Path Using Recursive Triggers Q222657 KB222657 November 3, 2003
308518 INF: Refresh of Current Activity in SEM May Cause "Error 1222: Lock Request time out period exceeded" Error Message Q308518 KB308518 October 31, 2003
292442 INF: How to Use the Windows Synchronize Manager with Pull Subscribers Q292442 KB292442 October 31, 2003
279660 INF: How to Query with Data Using SQL Mail and Exchange Server Q279660 KB279660 October 31, 2003
277535 INF: How to Install Localized SQL Server Error Messages Q277535 KB277535 October 31, 2003
275312 INF: SQL Server Procedure to Change Object Owner Q275312 KB275312 October 31, 2003
266694 INF: ALTER TABLE with ADD COLUMN and DEFAULT May Take a Long Time on a Large Data Set Q266694 KB266694 October 31, 2003
255937 INF: How to Create and Attach a Removable SQL 7.0 Database Q255937 KB255937 October 31, 2003
245245 INF: Sorting Dimension Members in OLAP Services Q245245 KB245245 October 31, 2003
306230 INF: How to Check the ANSI Settings Under Parsing Time Q306230 KB306230 October 30, 2003
242543 INF: DTS Row Level Restartability After an Unexpected Failure Q242543 KB242543 October 30, 2003
44519 INF: Error Handling in Transact-SQL Blocks and Stored Procedures Q44519 KB44519 October 30, 2003
275685 INF: Importing Performance Monitor Logs into SQL Server Q275685 KB275685 October 29, 2003
221465 INF: Using the WITH MOVE Option with the RESTORE Statement Q221465 KB221465 October 28, 2003
325334 INF: SQL Server and Striped Backups Q325334 KB325334 October 17, 2003
323895 INF: One Solution for a One-to-Many Distinct Rowcount Problem Q323895 KB323895 October 17, 2003
323161 INF: Avoid Using Device Names as Database Names Q323161 KB323161 October 17, 2003
322331 INF: ADO.NET Primer (White Paper) Q322331 KB322331 October 17, 2003
315689 INF: SQL Query Analyzer Color Code Information Q315689 KB315689 October 17, 2003
314648 INF: Differences in STATISTICS IO, SQL Profiler and Sysprocesses IO Counters Q314648 KB314648 October 17, 2003
303459 INF: How to Improve the Performance of Full-Text Search Queries for Large Database Tables Q303459 KB303459 October 17, 2003
277629 INF: SQL Server 2000 Upgrade Fails Because Database is Not in a Writable State Q277629 KB277629 October 17, 2003
270716 INF: You Cannot Use xp_loginconfig to Set Configuration Values Q270716 KB270716 October 17, 2003
257856 INF: SQL Server Agent Automatically Sets "Trunc. Log on Chkpt" for MSDB Q257856 KB257856 October 17, 2003
247193 INF: Database Property Sheet Displayed Incorrectly Q247193 KB247193 October 17, 2003
246181 INF: SQL 6.5 Database Upgrade with a Space in the Path to Master.dat Fails Q246181 KB246181 October 17, 2003
234181 INF: Logins Aliased to Databases Users Cannot Be Viewed from SQL Enterprise Manager Q234181 KB234181 October 17, 2003
232196 INF: Log Space Used Appears to Grow After Restoring from Backup Q232196 KB232196 October 17, 2003
232195 INF: Proper Use of the COLUMNS_UPDATED() Function Q232195 KB232195 October 17, 2003
231830 INF: Insertion of Strings Containing Trailing Spaces Q231830 KB231830 October 17, 2003
214602 INF: sp_dbcmptlevel 'master' is not Allowed Q214602 KB214602 October 17, 2003
207396 INF: Cannot See Actual Data Values for Columns in Enterprise Manager Q207396 KB207396 October 17, 2003
200117 INF: Not Possible to Remove Optional Components of SQL Server Q200117 KB200117 October 17, 2003
198851 INF: User Cannot Bind Rule to UDDT Created By Different User Q198851 KB198851 October 17, 2003
322877 INF: SAP Retail - Benchmark (White Paper) Q322877 KB322877 October 16, 2003
322328 INF: SQLXML Managed Classes (White Paper) Q322328 KB322328 October 16, 2003
312983 INF: Lotus Notes GUID Format Different Than SQL Server GUID Q312983 KB312983 October 16, 2003
308870 INF: COLLATE for Computed Columns is Deterministic for UNICODE Starting with SQL Server Service Pack 2 Q308870 KB308870 October 16, 2003
306628 INF: Inconsistent Behavior with Object Ownership with db_owner Created Objects Q306628 KB306628 October 16, 2003
302747 INF: Japanese_Unicode Collation is Not Supported on Windows 2000 Q302747 KB302747 October 16, 2003
271669 INF: Distributed Queries are not Run as Parallel Query Steps Q271669 KB271669 October 16, 2003
216575 INF: xp_enum_oledb_providers Enumerates the OLE DB Providers Q216575 KB216575 October 16, 2003
815436 INF: Use Trace Flag 3505 to Control SQL Server Checkpoint Behavior Q815436 KB815436 October 3, 2003
323049 INF: What's New in SQL Server 2000 (White Paper) Q323049 KB323049 October 3, 2003
323044 INF: Technology Comparison Discussion: SQL Server 2000 and Oracle8i (White Paper) Q323044 KB323044 October 3, 2003
322878 INF: SAP Sales and Distribution - Benchmark (White Paper) Q322878 KB322878 October 3, 2003
322720 INF: Price Comparisons (White Paper) Q322720 KB322720 October 3, 2003
322716 INF: PeopleSoft eBill Payment - Benchmark (White Paper) Q322716 KB322716 October 3, 2003
322700 INF: Microsoft's Business Internet Analytics (White Paper) Q322700 KB322700 October 3, 2003
322618 INF: Great Plains and SQL Server Benchmark Tests (White Paper) Q322618 KB322618 October 3, 2003
322353 INF: Choosing an Edition of SQL Server 2000 (White Paper) Q322353 KB322353 October 3, 2003
322334 INF: Using SQL Server 2000 to Build Database Applications in Visual Studio .NET (White Paper) Q322334 KB322334 October 3, 2003
322329 INF: Inside the SQLXML Virtual Directory Structure (White Paper) Q322329 KB322329 October 3, 2003
322324 INF: Transactional Replication Performance Tuning and Optimization (White Paper) Q322324 KB322324 October 3, 2003
322323 INF: Implementing Referential Integrity and Cascading Actions (White Paper) Q322323 KB322323 October 3, 2003
322322 INF: Identifying Common Administrative Issues for Microsoft SQL Server 2000 (White Paper) Q322322 KB322322 October 3, 2003
322321 INF: Middle Tier Application Data Caching with SQL Server 2000 (White Paper) Q322321 KB322321 October 3, 2003
322228 INF: Embedding MSDE 2000 Setup into the Setup of Custom Applications (White Paper) Q322228 KB322228 October 3, 2003
322227 INF: Microsoft SQL Server 2000 Distributed Queries: OLE DB Connectivity (White Paper) Q322227 KB322227 October 3, 2003
322100 INF: International Features in Microsoft SQL Server 2000 (White Paper) Q322100 KB322100 October 3, 2003
322096 INF: Statistics Used by the Query Optimizer in Microsoft SQL Server 2000 (White Paper) Q322096 KB322096 October 3, 2003
322070 INF: Talk to Your Data - Introduction to Microsoft English Query (MSEQ) for SQL Server 2000 (White Paper) Q322070 KB322070 October 3, 2003
315514 INF: Understanding Merge Replication Conflict Detection and Resolution Q315514 KB315514 October 3, 2003
307786 INF: Tracing to Network Drive May Reduce SQL Server Throughput Q307786 KB307786 October 3, 2003
305039 INF: -ForceConvergenceLevel Merge Agent Parameter is not Documented Q305039 KB305039 October 3, 2003
302115 INF: Initial Snapshot May Fail with Invalid Object Name When You Use User Defined Functions and Computed Columns Q302115 KB302115 October 3, 2003
293443 INF: The Autostart SQL Mail Option Does Not Appear in the SQL Enterprise Manager Q293443 KB293443 October 3, 2003
279033 INF: Identifying Cascading Referential Integrity from SQL Server Profiler Q279033 KB279033 October 3, 2003
278901 INF: Upgrade, Remove, or Add Components Not Available with Remote Installation Q278901 KB278901 October 3, 2003
275219 INF: Object Browser Makes a Separate Connection to SQL Server 2000 Q275219 KB275219 October 3, 2003
274517 INF: Table List in the Source Table Dialog Box Is Empty in SQL Profiler Q274517 KB274517 October 3, 2003
274075 INF: Hash Hint Is Ignored When a UNION Operator Follows an IN Operator Q274075 KB274075 October 3, 2003
272696 INF: HostName Column Blank for SPID Less Than 51 in SQL Profiler sp_who Q272696 KB272696 October 3, 2003
270052 INF: Table with Sql_variant Column Returns Rows That Match INT, MONEY, DECIMAL Data Types When INT Specified in WHERE Clause Q270052 KB270052 October 3, 2003
325757 INF: Using SQL Server 2000 with FIPS 140-1 Ciphers Q325757 KB325757 October 2, 2003
132224 INF: Network Encryption Available Using the Multi-Protocol Net Library Q132224 KB132224 September 24, 2003
283696 INF: Job to Monitor SQL Server 2000 Performance and Activity Q283696 KB283696 September 16, 2003
311826 INF: Index Tuning Wizard Best Practices Q311826 KB311826 September 15, 2003
818374 INF: SQL Server 2000 SP3 Creates a SQLDebugger Windows User Account Q818374 KB818374 July 7, 2003
314947 INF: How to Upgrade Virtual Servers from SQL Server 2000 Enterprise Evaluation Edition to SQL Server 2000 Enterprise Edition Q314947 KB314947 June 23, 2003
817296 INF: Change the Location of Temporary Files for Full-Text Searches Q817296 KB817296 June 13, 2003
248241 INF: Enabling SQL DMO Clients Without Installing the Client Side Utilities Q248241 KB248241 May 13, 2003
215520 INFO: COM+ and MTS Always Use SERIALIZABLE Transaction Isolation Level Q215520 KB215520 May 13, 2003
811482 INF: Handling SQL Server Error Messages When a Stored Procedure is Used in the SqlDataAdapter UpdateCommand Method Q811482 KB811482 May 8, 2003
328747 INF: Recovery Planning for Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Databases Q328747 KB328747 November 11, 2002
313185 INFO: Microsoft SQL Server 2000 Driver for JDBC Does Not Support HTTP Tunneling Q313185 KB313185 June 3, 2002

SQL Server 2000 articles, fixes and updates - letter I