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

• 2761934 Support for the varchar(max), nvarchar(max), and varbinary(max) data types is added in most OLE DB providers in SQL Server 2012 or in SQL Server 2008 or in SQL Server 2008 R2 Q2761934 KB2761934 April 13, 2023
• 974006 SQL Server query optimizer hotfix trace flag 4199 servicing model Q974006 KB974006 August 18, 2021
• 2979596 SQL Server 2008 Service Pack 4 release information Q2979596 KB2979596 January 26, 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
• 2632388 SQL NUMA Node IDs reported in SQL Errorlog may not match hardware NUMA node IDs Q2632388 KB2632388 January 25, 2021
• 2620201 SQL Server uses a service SID to provide service isolation Q2620201 KB2620201 January 25, 2021
• 819546 SQL Server support for mounted volumes Q819546 KB819546 January 25, 2021
• 2615479 SQL Server Replication Agents may exhibit blocking when applying snapshot Q2615479 KB2615479 December 17, 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
• 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
• 2496344 SQL Server Installation Center may display English content on a localized version of SQL Server after you apply a cumulative update Q2496344 KB2496344 November 20, 2019
• 2483962 [SDP 3][5da7d6cb-35c7-4eec-b453-04cceaa24307] SQL Server General Data Collection Diagnostic for Windows 7 and Windows Server 2008 R2 Q2483962 KB2483962 November 20, 2019
• 2446955 SSIS package may encounter an error 0xC0014100 on a computer that is running Windows Server 2008 or Windows Vista Q2446955 KB2446955 November 20, 2019
• 2000257 SQL Server installation fails if the Setup account doesn't have certain user rights Q2000257 KB2000257 February 18, 2019
• 195565 Statistical maintenance functionality (AutoStats) in SQL Server Q195565 KB195565 June 6, 2018
• 970667 SQL Server 2008 setup may fail with "Setup Failure in SetupActionName: cusetfeatureinstallstateaction " error message Q970667 KB970667 April 21, 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
• 958734 SQL Server failover cluster rolling patch and service pack process Q958734 KB958734 April 17, 2018
• 955404 SQL Server 2008 installation fails when you try to install SQL Server a second time Q955404 KB955404 April 17, 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
• 961301 SQL Server service may not start after patch installed Q961301 KB961301 April 13, 2018
• 956209 SSL no longer works after you remove an SSL binding from SQL Server 2008 Reporting Services by using the Reporting Services Configuration Management tool Q956209 KB956209 April 13, 2018
• 918760 SSIS package does not run when called from a SQL Server Agent job step Q918760 KB918760 June 30, 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
• 3150780 SQL Server Log Provider error when you configure SSIS in SQL Server 2014 Developer and SSDT Q3150780 KB3150780 April 21, 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
• 2564685 SQL Server 2008 resource does not come online after you apply updates on a cluster environment Q2564685 KB2564685 May 23, 2014
• 2696886 [SDP 3][ 788cfaf5-0665-4a69-8ecc-3931f459ecdb] SQL Base Diagnostics Collector Q2696886 KB2696886 May 13, 2014
• 2028589 SQL Server reports errors for exceptions, assertions, and hang conditions Q2028589 KB2028589 May 7, 2014
• 2673379 Some messages are rejected when you try to use Exchange Online servers as an SMTP relay for on-premises business applications and network hardware devices Q2673379 KB2673379 February 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
• 2621109 [SDP 3][a9a06d82-6a20-424a-b9ac-3f36236d4f5a] SQL Server Setup data-collection diagnostic tool Q2621109 KB2621109 October 25, 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
• 2700641 SQL Server Assertion error when you try to execute a Bulk Insert or BCP statement: "<loglock.cpp>, line=807 Failed Assertion = 'result == LCK_OK' " Q2700641 KB2700641 August 6, 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
• 2649165 SQL Server 2000 DTS Designer components are required to edit DTS packages Q2649165 KB2649165 May 24, 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
• 2216456 SQL Server 2008 Service Pack 2 and SQL Server 2008 R2 Service Pack 2 enhancements to the "Operation has been cancelled" error message text in Analysis Services Q2216456 KB2216456 May 14, 2012
• 2587929 SQL Server reports error 17310 after you apply the fix from KB 2515286 Q2587929 KB2587929 April 20, 2012
• 2519834 SQL Server reports "Operating system error 1117 (I/O Device Error)" on VMware ESX environments that are configured to use PVSCSI adapters Q2519834 KB2519834 April 19, 2012
• 2194498 SQL Server Best Practices Analyzer - Subscription Does not Match Publication Because Skipped Transactions Q2194498 KB2194498 April 17, 2012
• 2001727 SQL Server 2008 setup fails to complete when instance name contains Arabic characters Q2001727 KB2001727 April 13, 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
• 2647118 Stream_Blob_Columns enabled by default when Filestream is enabled Q2647118 KB2647118 January 9, 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
• 2216461 SQL Server 2008 setup fails to install on a Windows Server 2008-based cluster mount point Q2216461 KB2216461 July 29, 2011
• 2565842 Slow performance when you render a report on servers where Symantec Endpoint Protection is installed Q2565842 KB2565842 July 27, 2011
• 2513181 SQL Server 2008 full-text index on XML column do not index attribute values for the inner nodes Q2513181 KB2513181 July 13, 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
• 2280126 SQL Server 2008 full-text query may return false positives using number with more than 9 digits as search predicate condition Q2280126 KB2280126 January 18, 2011
• 2251397 SQL Server 2008 setup hangs on a x64 system with more than 32 logical processors Q2251397 KB2251397 October 22, 2010
• 2152728 SSIS 2008 Import Export Wizard can show numbers instead of data type Q2152728 KB2152728 September 15, 2010
• 2216465 Slipstream installation of SQL Server 2008 fails if the /PCUSOURCE or /CUSOURCE has a space in the path Q2216465 KB2216465 July 9, 2010
• 2120979 StreamInsight 1.0 updates that are released together with Cumulative Update package 2 for SQL Server 2008 R2 Q2120979 KB2120979 June 25, 2010
• 2022909 SQL Server 2008 and SQL Server 2008 R2 are not supported on some Windows Versions Q2022909 KB2022909 June 18, 2010
• 974626 SQL Server Performance Q974626 KB974626 June 16, 2010
• 2014130 SQL Server 2008 setup may fail with "Setup Failure in SetupActionName: <action name>" error message Q2014130 KB2014130 March 22, 2010
• 970771 SQL Server 2008 setup may fail with an unknown exception on MSVCR80.DLL Q970771 KB970771 March 2, 2010
• 972893 SQL Server 2008 Express supports .NET Framework 4 Beta 2 after you install Cumulative Update 5 for SQL Server 2008 Service Pack 1 Q972893 KB972893 November 24, 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
• 2001304 SQL Server 2008 SSIS Script Task fails on servers with Itanium processors Q2001304 KB2001304 October 1, 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
• 974829 Some packages of SQL Server 2008 Standard Edition for Small Business Server display incorrect information about supported operating systems Q974829 KB974829 August 31, 2009
• 2000219 SQL Server 2008 failover cluster installation can take a long time on Windows Server 2008 Q2000219 KB2000219 July 13, 2009
• 2000524 SQL Reporting services always passes string parameters as Unicode Q2000524 KB2000524 July 10, 2009
• 968905 Some Team Foundation Server 2008 Reports give errors with SQL Server 2008 Q968905 KB968905 June 30, 2009
• 971269 SQL Server 2008 setup program may fail with an unhandled exception when installing from a network location Q971269 KB971269 May 12, 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
• 969914 SQL Server 2008 setup may fail with "Setup Failure in SetupActionName: gatherusersettings" error message Q969914 KB969914 April 6, 2009
• 969521 SQL Server 2008 Cluster installation Fails with Validation error &#8220;The cluster validation either has not been run or contains errors or failures in the validation report. Refer to KB953748 or SQL Server Books Online for working around this issue.&#8221; Q969521 KB969521 March 25, 2009
• 956027 Some Dundas Chart features are missing after you convert a SQL Server 2005 Reporting Services report to SQL Server 2008 Reporting Services Q956027 KB956027 March 19, 2009
• 955716 Some columns incorrectly display the "date" column data type after you use the SQL Server Import and Export Wizard to import data from SQL Server 2008 Q955716 KB955716 March 19, 2009
• 955634 SSIS imports only one row into the dataflow when you use the ASE OLE DB provider from Sybase as the source in SQL Server 2008 Q955634 KB955634 March 19, 2009
• 955401 SQL Configuration Manager that is running on a Windows Server 2008-based domain controller does not restrict the change of a SQL Server 2008 engine service account to either a Network Service or a Local Service Q955401 KB955401 March 19, 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
• 958899 Setup log message makes user think setup is trying to install .Net 3.5 and incorrectly reports failure during locating media for .Net 3.5 Q958899 KB958899 October 16, 2008
• 958892 SQL Express default instance causes failure if Express is already installed Q958892 KB958892 October 16, 2008
• 955717 SQL Server 2008 performance decreases when you use a dataflow task that involves a fast load Q955717 KB955717 August 6, 2008
• 955628 SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pages Q955628 KB955628 July 29, 2008