SQL Server 2000 articles, fixes and updates - letter S

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 S that have been released. The list is daily updated.

• 826433 SQL Server diagnostics added to detect unreported I/O problems due to stale reads or lost writes Q826433 KB826433 January 26, 2021
• 322385 SQL Server support in a hyper-threaded environment Q322385 KB322385 January 26, 2021
• 819546 SQL Server support for mounted volumes Q819546 KB819546 January 25, 2021
• 327270 SQL Server is not supported on Windows Server 2003 or Windows Server 2008 Terminal Server application server Q327270 KB327270 May 31, 2020
• 2722715 Support for the leap second Q2722715 KB2722715 May 28, 2020
• 832017 Service overview and network port requirements for Windows Q832017 KB832017 May 28, 2020
• 949296 Some SQL Server replication agents cannot run when you configure many replication agents to run on a server Q949296 KB949296 April 30, 2020
• 832524 SQL Server technical bulletin - How to resolve a deadlock Q832524 KB832524 June 28, 2019
• 195565 Statistical maintenance functionality (AutoStats) in SQL Server Q195565 KB195565 June 6, 2018
• 924947 SQL Server significantly increases the unused space for some tables Q924947 KB924947 April 20, 2018
• 827575 SQL Server does not finish execution of a large batch of SQL statements Q827575 KB827575 April 20, 2018
• 328383 SQL Server clients may change protocols when the client computers try to connect to an instance of SQL Server Q328383 KB328383 April 20, 2018
• 282254 SQL Server service does not start successfully because of a logon failure Q282254 KB282254 April 17, 2018
• 307197 SQL Server cannot bind to the TCP/IP port on which SQL Server is listening when the TCP\IP port is used by another application Q307197 KB307197 April 13, 2018
• 913399 Space that a table uses is not completely released after you use a DELETE statement to delete data from the table in SQL Server Q913399 KB913399 March 30, 2017
• 833770 Support for SQL Server on iSCSI technology components Q833770 KB833770 May 11, 2015
• 911848 SQL Server incorrectly returns rows that have a NULL value when you try to filter non-Unicode data columns for records from a table Q911848 KB911848 January 17, 2015
• 905131 SQL Server 2000 may experience errors and stop responding, and error messages may be logged in the SQL Server 2000 error log, when you try to perform a write operation that is not logged Q905131 KB905131 January 17, 2015
• 884593 SQL Server 2000 may overcommit physical memory on computers that are running Windows XP Q884593 KB884593 January 17, 2015
• 928322 SQL Server performance counters may not appear when you use System Monitor to monitor the performance counters on a remote computer that is running SQL Server 2000 Q928322 KB928322 January 16, 2015
• 267263 SQL Server 2000 concurrent snapshot is not supported for SQL Server 7.0 pull subscriptions Q267263 KB267263 January 16, 2015
• 931303 SQL Server 2000 Service Pack 4 stops responding after you close a SQL Server connection on a computer that is running Windows Server 2003 Service Pack 1 Q931303 KB931303 January 15, 2015
• 918035 SQL Server 2000 64-bit eagerly acquires the amount of memory that is specified in the min server memory configuration option Q918035 KB918035 January 15, 2015
• 827260 SQL Server 2000 Performance Counters Do Not Appear in the Performance Collection Rules of the SQL Server Management Pack Q827260 KB827260 January 10, 2015
• 312995 SQL Server 2000 installation fails with "...previous program installation..." error message Q312995 KB312995 June 22, 2014
• 816628 SQL Server CE Web Service Extensions are removed Q816628 KB816628 February 27, 2014
• 814853 SQL Server CE Replication application fails with error message 29045 Q814853 KB814853 February 27, 2014
• 811430 SQL Server 2000 supports IPSec on Windows Server 2003 clusters Q811430 KB811430 February 27, 2014
• 833634 SAPWD is incorrectly translated as SAPWP in an error message in the Spanish version of the SQL Server 2000 Desktop Engine (MSDE) SP3 Setup program Q833634 KB833634 November 2, 2013
• 303680 SQL Server 2000 MSDE Service Pack 1 Setup on Windows 98 computer fails with error message Q303680 KB303680 November 2, 2013
• 299797 Sample: Analysis Services Writeback Sample Q299797 KB299797 October 26, 2013
• 811479 SQL Server Desktop Engine 2000 Setup fails when you log on with an account that has administrative user rights by using the fast user switching operation in Windows XP Q811479 KB811479 April 24, 2013
• 951288 SQL Server records a backup operation in the backupset history table when you use VSS to back up files on a volume Q951288 KB951288 March 28, 2013
• 263968 Service pack installation may save the system administrator password in a file Q263968 KB263968 October 23, 2012
• 2022254 SQL Server may report an 18272 error during restore operations Q2022254 KB2022254 May 24, 2011
• 2028963 Support policy for SQL Server 2000 on newer Operating Systems Q2028963 KB2028963 September 14, 2010
• 2000255 SQL Server 2005 default instance may not start when there is a SQL Server 2000 named instance and both instances are configured to listen on named pipes Q2000255 KB2000255 June 26, 2009
• 967096 SharePoint users are incorrectly offered a SQL Server 2000 Desktop Engine (Windows) update when they try to install the security update in Microsoft Knowledge Base article 960082 Q967096 KB967096 May 14, 2009
• 968759 SQL Server fails to start if NIC has multiple IP address Q968759 KB968759 March 9, 2009
• 967093 SQL Server 2000 Desktop Engine (Windows) (WMSDE) is uninstalled when you use the "Add or Remove Programs" item in Control Panel to uninstall a security update for SQL Server 2000 and for MSDE 2000 Q967093 KB967093 February 10, 2009
• 154628 SQL Server logs 17832 with multiple TCP\IP connection requests Q154628 KB154628 September 24, 2008
• 953739 SQL Server 2005 installers do not update an instance of the SQL Server service that is in a disabled state Q953739 KB953739 July 10, 2008
• 953743 Supported method for applying updates to SQL Server 7.0 Q953743 KB953743 June 10, 2008
• 953742 SQL Server 2000 and MSDE 2000 installers stop dependent services Q953742 KB953742 June 10, 2008
• 953741 SQL Server 2005 installers stop dependent services Q953741 KB953741 June 10, 2008
• 306457 SQLAGENT job waiting on worker thread Q306457 KB306457 May 13, 2008
• 324453 Support WebCast: Integrating Microsoft .NET Development with Microsoft SQL Server 2000 Q324453 KB324453 December 3, 2007
• 298897 SAMPLE Stored Procedures That Helps Map SIDs Between User and Master Databases When A Database Is Moved Q298897 KB298897 November 26, 2007
• 922658 SQL Server 2000 or SQL Server 2005 may temporarily stop responding on a Windows Server 2003 Service Pack 1-based computer Q922658 KB922658 November 20, 2007
• 810185 SQL Server 2000 hotfix update for SQL Server 2000 Service Pack 3 and 3a Q810185 KB810185 November 20, 2007
• 889551 Service Pack 3a for Microsoft SQL Server 2000 April 9, 2003 Q889551 KB889551 November 16, 2007
• 824462 SqlCeCommand objects are not automatically disposed if you use a SqlCeDataAdapter object Q824462 KB824462 November 14, 2007
• 813842 SQL Server 2000 Evaluation Edition supports security patch Q813842 KB813842 November 7, 2007
• 316333 SQL Server 2000 Security Update for Service Pack 2 Q316333 KB316333 November 7, 2007
• 288095 Stack overflow occurs when you run a query that contains a large number of arguments inside an IN or a NOT IN clause in SQL Server Q288095 KB288095 November 2, 2007
• 811168 SQL Server 2000 Service Pack 3, Service Pack 3a, or Service Pack 4 pre-installation checklist for SQL Server 2000 virtual server for failover clustering Q811168 KB811168 October 29, 2007
• 330971 SQL Server 2000 Windows CE Edition 2.0 for Visual Studio .NET 2003 Q330971 KB330971 October 29, 2007
• 309398 SQL Server 2000 installation or local connections fail with "SSL Security error :ConnectionOpen (SECDoClientHandshake())" error message Q309398 KB309398 October 29, 2007
• 325485 Support WebCast: Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack Installation Q325485 KB325485 September 21, 2007
• 890263 SQL Server 2000 stops responding when you query lots of data with a large packet size connected over a VIA protocol Q890263 KB890263 May 18, 2007
• 811031 SQL Server Agent job fails when the job uses a linked server and the job owner is not a system administrator Q811031 KB811031 May 10, 2007
• 291332 SERVERPROPERTY returns incorrect value for LICENSETYPE Q291332 KB291332 April 30, 2007
• 831920 Support WebCast: Pass Order and Solve Order in Microsoft SQL Server 2000 Analysis Services Q831920 KB831920 April 29, 2007
• 822250 Support WebCast: Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures Q822250 KB822250 April 29, 2007
• 822144 Support WebCast: Microsoft SQL Server 2000 SP 3a: What It Is, Why It Is, and Whether to Upgrade Q822144 KB822144 April 29, 2007
• 821786 Support WebCast: Microsoft SQL Server 2000: Using Log Shipping Q821786 KB821786 April 29, 2007
• 818714 Support WebCast: Microsoft SQL Server 2000: The Types of Replication and When to Implement Each Q818714 KB818714 April 29, 2007
• 817280 Support WebCast: Microsoft SQL Server 2000: An Introduction to SQL Server 2000 (64-bit) and Analysis Services (64-bit) Q817280 KB817280 April 29, 2007
• 812817 Support WebCast: Microsoft SQL Server 2000: Troubleshooting Connectivity Q812817 KB812817 April 29, 2007
• 811064 Support WebCast: Microsoft SQL Server 2000: Full-Text Search and Service Pack 3 Q811064 KB811064 April 29, 2007
• 842191 SQL Server 2000 Windows CE Edition 1.0 and 1.1 frequently asked questions Q842191 KB842191 April 26, 2007
• 832526 SQL Server Technical Bulletin - The Index Tuning Wizard Q832526 KB832526 April 25, 2007
• 934378 Space is not released after you delete some rows from a table in SQL Server 2000 Q934378 KB934378 April 4, 2007
• 833557 Support WebCast: Middle-tier Applications and Analysis Services Q833557 KB833557 March 30, 2007
• 823884 Support WebCast: Installing and Troubleshooting Microsoft SQL Server 2000 Service Packs Q823884 KB823884 March 30, 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
• 313173 Sample connection pool manager for use with Microsoft SQL Server 2000 Driver for JDBC Q313173 KB313173 February 23, 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
• 324914 SQL Server Connection Fails When RC4 Encryption Is Disabled Q324914 KB324914 February 22, 2007
• 229564 SQL application role errors with OLE DB resource pooling Q229564 KB229564 February 15, 2007
• 325808 SQL Server 2000 Windows CE Edition component releases and versions Q325808 KB325808 February 12, 2007
• 321190 SQL Server cluster supportability with MCMS 2002 and with MCMS 2001 Q321190 KB321190 February 10, 2007
• 326839 Support WebCast: Microsoft SQL Server: How to Configure, Manage, Use, and Troubleshoot Linked Servers Q326839 KB326839 February 1, 2007
• 324362 Subqueries that you define on merge articles are not re-evaluated Q324362 KB324362 January 29, 2007
• 277658 Setspn fails if domain name differs from NetBIOS name where SQL Server SPN is registered Q277658 KB277658 January 29, 2007
• 826818 SQL Server 2000 Release A replaces SQL Server 2000 Q826818 KB826818 January 17, 2007
• 891058 SQL Server 2000 Reporting Services does not install correctly after you install the .NET Framework 2.0 Beta Q891058 KB891058 January 16, 2007
• 842907 SQL Server CE 1.0 and later version client programs may not be able to connect to IIS on computers that are running Windows XP Service Pack 2 (SP2) Q842907 KB842907 January 3, 2007
• 817788 Support WebCast: Microsoft SQL Server 2000 Desktop Engine (MSDE) Installation, Deployment, and Patching Q817788 KB817788 December 19, 2006
• 810587 Support WebCast: Microsoft SQL Server 2000 Service Pack 3 Q810587 KB810587 December 19, 2006
• 273554 SMS: License Requirements for Servers and Clients That Are Using SMS Q273554 KB273554 October 27, 2006
• 325229 Support WebCast: Microsoft SQL Server 2000 Windows CE Edition Overview and Programming Q325229 KB325229 August 8, 2006
• 324669 Support WebCast: Programming ADO SQLXML to Execute SQLXML Queries Q324669 KB324669 August 2, 2006
• 324728 Support WebCast: SQL Server CE Tips and Troubleshooting Q324728 KB324728 June 28, 2006
• 271782 SAMPLE: How To Retrieve XML Data Using an XPath Query with ADO in Visual C++ Q271782 KB271782 April 18, 2006
• 811891 SQL Server only uses 2 GB of memory even though the AWE option is enabled Q811891 KB811891 April 12, 2006
• 330199 "Syntax Error Or Access violation" Error With ASCII Sequence In SQL Q330199 KB330199 April 7, 2006
• 302491 SQL Server 2000 Cluster Setup may fail to perform required operations on the cluster nodes when special characters are used in the resource name Q302491 KB302491 April 7, 2006
• 330391 SQL Server hotfix installer Q330391 KB330391 April 6, 2006
• 327322 SQL Server 2000 Enterprise Manager polling may cause ClientToken errors in the Cluster log file Q327322 KB327322 April 6, 2006
• 289828 SQL Server Setup in a cluster environment encounters an access violation if you have a long computer name Q289828 KB289828 April 6, 2006
• 296890 SQL Server 2000 fails to install on a cluster if the service startup account contains a space Q296890 KB296890 March 18, 2006
• 183692 SQL Server Setup program stops responding after you copy the files successfully Q183692 KB183692 December 28, 2005
• 301292 SET OPTION considerations when running DBCC with indexes on computed columns Q301292 KB301292 December 20, 2005
• 309182 Slow DELETE or UPDATE against non-SQL linked server Q309182 KB309182 December 13, 2005
• 328947 SQLDescribeParam Returns Errors If the Query Involves an Outer Join Q328947 KB328947 October 11, 2005
• 812920 Support WebCast: Microsoft Baseline Security Analyzer Version 1.1 Q812920 KB812920 August 17, 2005
• 329863 Support WebCast: Using the XML Analysis Services Provider to Retrieve Data Q329863 KB329863 July 11, 2005
• 307802 SQL Server error 8510 may be reported unnecessarily Q307802 KB307802 February 28, 2005
• 272688 Sqldiag utility defaults to SQL 7.0 path if SQL Server 7.0 is the default instance Q272688 KB272688 December 21, 2004
• 321824 SQL Server Agent cannot start after it attaches a SQL Server 7.0 MSDB database to SQL Server 2000 Q321824 KB321824 December 17, 2004
• 277029 SQL Server 7.0 as master server cannot enlist SQL Server 2000 named instance as target server Q277029 KB277029 December 17, 2004
• 285295 SQL Server 2000 changes name of RETURN_VALUE to @RETURN_VALUE Q285295 KB285295 December 15, 2004
• 325106 Support WebCast: Introduction to Microsoft SQL Server 2000 Clustering Q325106 KB325106 November 17, 2004
• 324966 Support WebCast: Introducing New Features in Microsoft SQL Server 2000 Transactional Replication Q324966 KB324966 November 17, 2004
• 323739 SQL Server 2000 Full-Text Search Deployment white paper Q323739 KB323739 October 4, 2004
• 325119 Support WebCast: Analyzing Optimal Compiled Plan Caching Q325119 KB325119 August 10, 2004
• 325493 Support WebCast: The DTS Multiphase Data Pump Q325493 KB325493 August 9, 2004
• 325474 Support WebCast: Microsoft SQL Server 2000: Alternate Synchronization Partner Q325474 KB325474 August 9, 2004
• 325304 Support WebCast: Microsoft SQL Server 2000: New XML Features Q325304 KB325304 August 9, 2004
• 325275 Support WebCast: Cascading Referential Integrity Constraints in SQL Server 2000 Q325275 KB325275 August 9, 2004
• 325263 Support WebCast: SQL Server 2000 Profiler: What's New and How to Effectively Use It Q325263 KB325263 August 9, 2004
• 325257 Support WebCast: SQL Server 2000 Database Recovery: Backup and Restore Q325257 KB325257 August 9, 2004
• 325220 Support WebCast: Microsoft SQL Server 2000 Log Shipping Q325220 KB325220 August 9, 2004
• 325150 Support WebCast: Multi-instancing in Microsoft SQL Server 2000 Q325150 KB325150 August 9, 2004
• 325120 Support WebCast: Microsoft SQL Server 2000: Merge Replication Enhancements Q325120 KB325120 August 9, 2004
• 325105 Support WebCast: Understanding User-Defined Functions in Microsoft SQL Server 2000 Q325105 KB325105 August 9, 2004
• 325024 Support WebCast: Effective Indexing and Statistics with SQL 2000 Q325024 KB325024 August 9, 2004
• 324982 Support WebCast: Data Transformation Services Package Scheduling - An Inside Look Q324982 KB324982 August 9, 2004
• 324974 Support WebCast: New Features in XML for Microsoft SQL Server 2000 Web Release 2 Q324974 KB324974 August 9, 2004
• 324961 Support WebCast: Microsoft SQL Server 2000 Analysis Services: How to Connect to Analysis Services over the Internet Q324961 KB324961 August 9, 2004
• 324885 Support WebCast: Microsoft SQL Server: Rapid Blocker Script Analysis Q324885 KB324885 August 9, 2004
• 324812 Support WebCast: Microsoft SQL Server 2000 Virtual Server: Things You Should Know Q324812 KB324812 August 9, 2004
• 324786 Support WebCast: Microsoft SQL Server 2000: How to Create and Consume Web Services Using SQLXML 3.0 Q324786 KB324786 August 9, 2004
• 324777 Support WebCast: Microsoft SQL Server 2000: How to Configure SSL Encryption Q324777 KB324777 August 9, 2004
• 324692 Support WebCast: How to Collect and Analyze Performance Data in Microsoft SQL Server Q324692 KB324692 August 9, 2004
• 324689 Support WebCast: Troubleshooting Microsoft SQL Mail Q324689 KB324689 August 9, 2004
• 324667 Support WebCast: Accessing and Manipulating Data in Microsoft SQL Server 2000 Databases by Using SQLXML UpdateGrams Q324667 KB324667 August 9, 2004
• 324665 Support WebCast: Microsoft SQL Server 2000 Transactional Replication: Queued Updating Subscription Q324665 KB324665 August 9, 2004
• 324613 Support WebCast: Database Normalization Basics Q324613 KB324613 August 9, 2004
• 324608 Support WebCast: Troubleshooting Database Connectivity Issues in Programming with ASP Q324608 KB324608 August 9, 2004
• 272185 SAMPLE: How to Retrieve Data Using a SQL XML Query in ATL OLE DB Q272185 KB272185 August 9, 2004
• 271780 SAMPLE: How To Retrieve XML Data Using an SQL XML Query with ADO in Visual C++ Q271780 KB271780 August 9, 2004
• 271775 SAMPLE: How To Retrieve Relational Data Using OpenXML with ADO in Visual C++ Q271775 KB271775 August 9, 2004
• 303343 SQL Server 2000 User-Defined Functions White Paper Q303343 KB303343 August 5, 2004
• 288054 SAMPLE: RLockMFC.exe Demonstrates Row-Level Locking Using MFC and SQL Server Q288054 KB288054 August 5, 2004
• 272181 SAMPLE: How to Retrieve Data Using a Template File in ATL OLE DB Q272181 KB272181 August 5, 2004
• 272180 SAMPLE: How to Retrieve XML Data Using a Template File with ADO in Visual C++ Q272180 KB272180 August 5, 2004
• 272177 SAMPLE: Using OLEDB Templates to Retrieve XML Data Through XPath Query Q272177 KB272177 August 5, 2004
• 272176 SAMPLE: How to Run Singleton SELECT Queries in Visual C++ Q272176 KB272176 August 5, 2004
• 329833 Support WebCast: Microsoft SQL Server 2000: Understanding Backup and Restore Q329833 KB329833 August 4, 2004
• 327396 Support WebCast: Performance Tuning Analysis Services Q327396 KB327396 August 4, 2004
• 325239 Support WebCast: Understanding INSTEAD OF Triggers in Microsoft SQL Server 2000 Q325239 KB325239 June 22, 2004
• 831133 SQL Server clients are authenticated as guests if Simple File Sharing is enabled Q831133 KB831133 May 27, 2004
• 815327 Support Webcast: Microsoft SQL Server: Slammer Virus Update Q815327 KB815327 May 6, 2004
• 814522 Support Webcast: Microsoft SQL Server: Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering Q814522 KB814522 May 6, 2004
• 122352 Supported Windows versions for SQL Server Q122352 KB122352 April 7, 2004
• 814848 SQL Server 2000 may not start after you use the Windows Backup system tool Q814848 KB814848 April 6, 2004
• 834661 SQL Server 2000 Setup requires a drive letter when you use mounted drives Q834661 KB834661 March 12, 2004
• 810927 Support for Data Transformation Services in SQL Server 2000 64-bit Q810927 KB810927 January 9, 2004