SQL Server 2005 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 2005 starts with letter S that have been released. The list is daily updated.

• 974006 SQL Server query optimizer hotfix trace flag 4199 servicing model Q974006 KB974006 August 18, 2021
• 980653 SQL Server 2008 R2 CU2, SQL Server 2008 SP1 CU7 and SQL Server 2005 SP3 CU9 introduce trace flag 4136 to disable the "parameter sniffing" process Q980653 KB980653 January 26, 2021
• 970070 Support for Locked Pages on SQL Server Standard Edition (64-bit) systems Q970070 KB970070 January 26, 2021
• 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
• 2926557 SQL Server VDI backup and restore operations require Sysadmin privileges Q2926557 KB2926557 January 25, 2021
• 2860895 SQL Server is not supported on a Windows operating system on which case sensitivity is enabled Q2860895 KB2860895 January 25, 2021
• 2795690 SQL Server agent crashes when you try to start it or takes longer than expected to start Q2795690 KB2795690 January 25, 2021
• 957008 SQL Server 2005 Service Pack 2 is not successfully updated when you try to install or to uninstall a security update Q957008 KB957008 January 25, 2021
• 819546 SQL Server support for mounted volumes Q819546 KB819546 January 25, 2021
• 931279 SQL Server timing values may be incorrect when you use utilities or technologies that change CPU frequencies Q931279 KB931279 December 1, 2020
• 2874903 "System.OutOfMemoryException" exception when you execute a query in SQL Server Management Studio Q2874903 KB2874903 August 20, 2020
• 2295405 SQL Server service crashes when you run an Oracle linked server query Q2295405 KB2295405 August 18, 2020
• 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
• 949296 Some SQL Server replication agents cannot run when you configure many replication agents to run on a server Q949296 KB949296 April 30, 2020
• 919023 SQL Server 2005 connectivity and Volume Shadow Copy Service (VSS) Q919023 KB919023 April 9, 2020
• 956893 Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment Q956893 KB956893 March 31, 2020
• 2492477 SQL Agent job that executes a distributed query may fail with 65535, 782 or 7437 error messages Q2492477 KB2492477 February 4, 2020
• 2585240 SQL Server stored procedure custom conflict resolver adds "0x00" to conflicting columns Q2585240 KB2585240 November 20, 2019
• 968749 SQL Server 2005 setup fails if MSXML Core Services 6.0 is installed Q968749 KB968749 November 20, 2019
• 910229 SQL Server 2005 Express Edition Readme Q910229 KB910229 November 20, 2019
• 195565 Statistical maintenance functionality (AutoStats) in SQL Server Q195565 KB195565 June 6, 2018
• 941823 Some or all SQL Server 2005 services are not listed in SQL Server Configuration Manager, or you receive a "No SQL Server 2005 components were found" error message when you perform operations in SQL Server 2005 Surface Area Configuration Q941823 KB941823 April 20, 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
• 972387 SQL Server Failover Cluster Instance is taken offline when you change the password for the service account on the passive node Q972387 KB972387 April 19, 2018
• 911305 SQL Server Agent jobs may fail after you change the SQL Server Agent service startup account by using the Windows Service Control Manager Q911305 KB911305 April 17, 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
• 918760 SSIS package does not run when called from a SQL Server Agent job step Q918760 KB918760 June 30, 2017
• 915845 SQL Server Agent jobs fail when the jobs contain job steps that use tokens after you install SQL Server 2005 Service Pack 1 Q915845 KB915845 March 30, 2017
• 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
• 900497 SQL Server 2005 does not start when you upgrade SQL Server 2000 to SQL Server 2005 Q900497 KB900497 February 15, 2017
• 2023869 SQL Server fails to start with error 17182 "TDSSNIClient initialization failed with error 0xd, status code 0x38" when server is configured to use SSL Q2023869 KB2023869 May 10, 2016
• 910378 Scalable shared databases are supported by SQL Server 2005 Q910378 KB910378 May 12, 2015
• 833770 Support for SQL Server on iSCSI technology components Q833770 KB833770 May 11, 2015
• 3053639 SQL Server query that typecasts a Unicode column to a binary collation returns incorrect results Q3053639 KB3053639 April 3, 2015
• 2979636 SQL Server generates a 3023 message when backup and file operations are tried at the same time Q2979636 KB2979636 July 3, 2014
• 2696886 [SDP 3][ 788cfaf5-0665-4a69-8ecc-3931f459ecdb] SQL Base Diagnostics Collector Q2696886 KB2696886 May 13, 2014
• 2900760 SQLDescribeCol returns the wrong column length and data type in a complex union query that has parameters Q2900760 KB2900760 November 9, 2013
• 2871695 [SDP 3][ab09ed03-7576-425f-aae0-8f36c0e8c662] Information that is collected by the SQL Server Connectivity Diagnostics Collector Q2871695 KB2871695 October 25, 2013
• 2773194 [SDP 3] [155888db-ad84-4e39-a4e1-f6e6c3b185b4] Information that is collected by SQL RS Diagnostics Collector Q2773194 KB2773194 October 25, 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
• 922672 Support policy for untested .NET Framework assemblies in the SQL Server CLR-hosted environment Q922672 KB922672 March 8, 2013
• 2755960 SQL query performance might decrease when the SQL Server Database instance has high index fragmentation Q2755960 KB2755960 September 27, 2012
• 2664701 Support in SQL Server for custom COM-based conflict resolvers that handle merge replication Q2664701 KB2664701 July 9, 2012
• 2137408 SQL Server logs "Msg 833" when I/O delay problems occur Q2137408 KB2137408 July 9, 2012
• 2000380 SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes Q2000380 KB2000380 June 26, 2012
• 2001221 SQL Server reports 701: "There is insufficient memory to run this query" when executing large batches Q2001221 KB2001221 May 23, 2012
• 2585632 Synchronization for SQL Server merge replication fails when an article uses a stored procedure custom conflict resolver Q2585632 KB2585632 May 22, 2012
• 2587929 SQL Server reports error 17310 after you apply the fix from KB 2515286 Q2587929 KB2587929 April 20, 2012
• 2033590 SQL Server records the date/time of the most recent database consistency check with no errors Q2033590 KB2033590 April 3, 2012
• 2091024 SQL Server reports Msg 5144 and 5145 for long or failed autogrow of databases and transaction log files Q2091024 KB2091024 April 2, 2012
• 2033523 Separate database and transaction log files on different drives for optimal performance and disaster recovery Q2033523 KB2033523 April 2, 2012
• 982900 SQL Merge Replication Non-Convergence Q982900 KB982900 October 5, 2011
• 2624458 SSIS Checkpoints are not honored for For Loop or Foreach Loop container items Q2624458 KB2624458 October 3, 2011
• 2591380 System Center Operations Manager 2007 Support for SQL 2005 SP4 Q2591380 KB2591380 August 18, 2011
• 2022254 SQL Server may report an 18272 error during restore operations Q2022254 KB2022254 May 24, 2011
• 2004738 SQL Failure Occurs During the Installation of HPC Pack 2008 Q2004738 KB2004738 May 2, 2011
• 2523164 SQL Server configuration changes may not be installed because they have not been reconfigured or SQL Server has not been restarted Q2523164 KB2523164 March 17, 2011
• 2003488 SQL Server failover installation fails when the setup account does not have permissions on Windows time service Q2003488 KB2003488 April 2, 2010
• 978026 Some drivers no longer function after you install SQL Server 2005 Q978026 KB978026 November 25, 2009
• 969936 Stop error message when you install SQL Server 2005 SP3, SQL Server 2005 Express SP3, or SQL Server 2008 on a Windows XP-based computer that is earlier than Windows XP SP3: "CRITICAL_OBJECT_TERMINATION" Q969936 KB969936 November 24, 2009
• 2003609 Schema changes are repeatedly enumerated by merge agent during synchronization operation of merge replication in SQL Server Q2003609 KB2003609 October 19, 2009
• 2000403 SQL Server 2005 cluster resources fail after a side by side installation of SQL Server 2008 on a Windows Server 2008 Q2000403 KB2000403 September 22, 2009
• 973993 Some nodes are not updated as expected when you apply Service Pack 3 or a post-Service Pack 3 update in a SQL Server 2005 cluster that is based on Windows Server 2008 R2 failover clustering Q973993 KB973993 August 4, 2009
• 2000524 SQL Reporting services always passes string parameters as Unicode Q2000524 KB2000524 July 10, 2009
• 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
• 970669 SQL Server 2008 specific folders are created on systems with SQL Server 2005 starting SP3 and above to prevent upgrade failures to SQL Server 2008 at a later time Q970669 KB970669 April 27, 2009
• 969159 SQL Server 2005 and SQL Server 2008 Websync Internet timeouts may not show any symptoms in Replication Monitor Q969159 KB969159 March 17, 2009
• 968795 SQL Server merge replication to SSCE fails with error: HTTP header information is either corrupted or missing in the transport message Q968795 KB968795 March 9, 2009
• 968759 SQL Server fails to start if NIC has multiple IP address Q968759 KB968759 March 9, 2009
• 933836 Security permissions that are associated with the existing roles may reset when you use the Analysis Services Deployment Wizard to deploy a SQL Server 2005 Analysis Services project Q933836 KB933836 October 6, 2008
• 154628 SQL Server logs 17832 with multiple TCP\IP connection requests Q154628 KB154628 September 24, 2008
• 956262 Supportability for SQL Server 2005 in a virtual machine environment Q956262 KB956262 July 28, 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
• 953170 Support WebCast: Microsoft SQL Server 2005 Failover Clustering on Windows Server 2008 Q953170 KB953170 June 30, 2008
• 945601 SQL Server 2005 Reporting Services e-mail subscriptions do not work in Windows Vista and in Windows Server 2008 if you use aliases as e-mail addresses Q945601 KB945601 June 16, 2008
• 922664 SQL Server is not supported on Intel-based Apple Macintosh computers that run a Windows operating system Q922664 KB922664 June 16, 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
• 945068 Some visual elements in SQL Server Management Studio lose functionality when you register many instances of SQL Server Q945068 KB945068 December 12, 2007
• 945539 SQL Server 2005 cannot index some 2007 Office document formats Q945539 KB945539 December 5, 2007
• 945066 SQL Server 2005 does not validate all articles in a transactional publication when you run the sp_publication_validation stored procedure to validate the articles Q945066 KB945066 December 5, 2007
• 935297 SQL Server Setup fails unexpectedly when you try to install SQL Server 2005 Service Pack 2 Q935297 KB935297 November 20, 2007
• 922767 Subscription distribution may fail after you synchronize a subscription in SQL Server 2005 Q922767 KB922767 November 20, 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
• 905617 SQL Server 2005 full-text search includes improved and updated noise word files Q905617 KB905617 November 20, 2007
• 824462 SqlCeCommand objects are not automatically disposed if you use a SqlCeDataAdapter object Q824462 KB824462 November 14, 2007
• 938495 Slow performance when you run an MDX query that accesses the key attribute hierarchy in a parent-child dimension in SQL Server 2005 Analysis Services Q938495 KB938495 October 31, 2007
• 930196 Support WebCast: Using Microsoft SQL Server 2005 Compact Edition Q930196 KB930196 August 27, 2007
• 927742 Support WebCast: SQL Server 2005 : Database backups and FullText Catalogs Q927742 KB927742 August 27, 2007
• 925068 Support WebCast: How to use the DataReader Source and the OLE DB Source objects in SQL Server 2005 Integration Services Q925068 KB925068 August 27, 2007
• 925067 Support WebCast: Overview of database mirroring in SQL Server 2005 Q925067 KB925067 August 27, 2007
• 937263 Support WebCast: How to use custom assemblies in SQL Server 2005 Reporting Services Q937263 KB937263 June 27, 2007
• 934750 Some shared components are not installed in the correct folder when you install SQL Server 2005 Express Edition on a computer that is running a 64-bit version of Windows Vista Q934750 KB934750 April 13, 2007
• 917398 Support for the Hong Kong collation in SQL Server 2005 Q917398 KB917398 March 16, 2007
• 321190 SQL Server cluster supportability with MCMS 2002 and with MCMS 2001 Q321190 KB321190 February 10, 2007
• 929664 Some menu items in Visual Studio 2005 are missing when you open or create a project in Visual Studio 2005 after you install SQL Server 2005 Business Intelligence Development Studio Q929664 KB929664 January 3, 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
• 910228 SQL Server 2005 Readme and installation requirements Q910228 KB910228 December 7, 2006
• 917421 Some rows are not displayed when you create a model-based report in SQL Server 2005 Reporting Services Q917421 KB917421 April 27, 2006
• 811891 SQL Server only uses 2 GB of memory even though the AWE option is enabled Q811891 KB811891 April 12, 2006
• 904798 SSIS packages that are currently running may unexpectedly stop responding when you restart the SSIS service in SQL Server 2005 Q904798 KB904798 March 11, 2006
• 910890 SSIS reports that a query was successful when a SQLOLEDB provider ends an SSIS query because of a server error Q910890 KB910890 March 3, 2006
• 913046 SQL Server 2005 Reporting Services does not save dump files to the location that you specify in the Dr. Watson for Windows tool Q913046 KB913046 February 14, 2006
• 183692 SQL Server Setup program stops responding after you copy the files successfully Q183692 KB183692 December 28, 2005
• 910892 SQL Server 2005 Notification Services does not start successfully when you restart the computer Q910892 KB910892 December 20, 2005
• 909804 SQL Server Reporting Services may stop responding for several minutes on an x64-based computer in SQL Server 2005, 64-bit version Q909804 KB909804 November 18, 2005