kbupdate.info ›
Daily Updated!
SQL Server 2008 articles, fixes and updates - Year 2021
Daily Updated!
chronological list: 2021 | 2020/12 10 9 8 5 4 3 2 | 2019 | 2018 | 2017 | 2016 | 2015 | ... 2003
alphabetical list: A B C D E F G H I K L M N O P Q R S T U V W X Y
This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2008 that have been released in Year 2021. The list is daily updated.
- 974006 SQL Server query optimizer hotfix trace flag 4199 servicing model Q974006 KB974006 August 18, 2021
- 4583468 Microsoft SQL Server elevation of privilege vulnerability Q4583468 KB4583468 April 16, 2021
- 3135244 TLS 1.2 support for Microsoft SQL Server Q3135244 KB3135244 February 25, 2021
- 2640027 FIX: SQL Server Agent job fails if you set the job schedule type as "Start automatically when SQL Server Agent starts" in SQL Server 2008 SP2, SQL Server 2008 SP3, SQL Server 2008 R2 SP1 or SQL Server 2008 R2 SP2 Q2640027 KB2640027 February 24, 2021
- 3135852 FIX: The encrypted endpoint communication with TLS 1.2 fails when you use SQL Server Q3135852 KB3135852 January 26, 2021
- 3034373 An on-demand hotfix update package is available for SQL Server 2008 SP4 Q3034373 KB3034373 January 26, 2021
- 3030352 FIX: The change table is ordered incorrectly for updated rows after you enable change data capture for a Microsoft SQL Server database Q3030352 KB3030352 January 26, 2021
- 3027857 FIX: Error 832 occurs after you apply update MS14-044 to SQL Server 2008 R2 or SQL Server 2008 Q3027857 KB3027857 January 26, 2021
- 3005011 Unexpected growth of tempdb data files when using SQL Server Service Broker Q3005011 KB3005011 January 26, 2021
- 2994310 FIX: Distribution Agent for Oracle subscription fails when you use SQL Server 2008 R2 or SQL Server 2008 Q2994310 KB2994310 January 26, 2021
- 2979596 SQL Server 2008 Service Pack 4 release information Q2979596 KB2979596 January 26, 2021
- 2967240 FIX: Cannot reclaim unused space by using shrink operation in the table that contains a LOB column in SQL Server Q2967240 KB2967240 January 26, 2021
- 2966940 INFO: Extended Events Histogram target may show unexpected results Q2966940 KB2966940 January 26, 2021
- 2966114 FIX: Incorrect results when you run a full-text search on a phrase that contains a hyphen in SQL Server 2008 Q2966114 KB2966114 January 26, 2021
- 2963658 FIX: The TDE enabled database stops responding indefinitely on WRITELOG or LOGBUFFER wait in SQL Server Q2963658 KB2963658 January 26, 2021
- 2963408 FIX: Error 5180 occurs when you query BLOB column data in SQL Server Q2963408 KB2963408 January 26, 2021
- 2958696 Cumulative Update 17 for SQL Server 2008 SP3 Q2958696 KB2958696 January 26, 2021
- 2936984 FIX: "Failed to generate dynamic snapshot" when you call sp_MScreatemergedynamicsnapshot in SQL Server Q2936984 KB2936984 January 26, 2021
- 2936421 Cumulative update package 16 for SQL Server 2008 Service Pack 3 Q2936421 KB2936421 January 26, 2021
- 2927325 FIX: Thesaurus expansion for phrases returns unexpected results in SQL Server 2008 or SQL Server 2008 R2 Q2927325 KB2927325 January 26, 2021
- 2926699 FIX: Operating system version information that is returned from SQL Server 2008 or SQL Server 2008 R2 or SQL Server 2012 is incorrect in Windows 8.1 Q2926699 KB2926699 January 26, 2021
- 2926217 FIX: Performance problems occur when database lock activity increases in SQL Server Q2926217 KB2926217 January 26, 2021
- 2923837 FIX: Merge Agent fails or you experience non-convergence when you use a custom stored procedure conflict resolver in SQL Server Q2923837 KB2923837 January 26, 2021
- 2923520 Cumulative update package 15 for SQL Server 2008 Service Pack 3 Q2923520 KB2923520 January 26, 2021
- 2921630 FIX: Incorrect result is returned when you run an MDX query that contains a DRILLTHROUGH statement in SSAS Q2921630 KB2921630 January 26, 2021
- 2919611 FIX: "Installer terminated prematurely" error when you install SQL Server 2008 SP3 or SQL Server 2008 R2 SP2 Q2919611 KB2919611 January 26, 2021
- 2893410 Cumulative update package 14 for SQL Server 2008 SP3 Q2893410 KB2893410 January 26, 2021
- 2892741 FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012 Q2892741 KB2892741 January 26, 2021
- 2889492 You cannot open the SQL Server Analysis Services properties dialog box in Windows 8.1 Q2889492 KB2889492 January 26, 2021
- 2887465 FIX: You receive an incorrect result when you run a query that uses some ranking functions in SQL Server 2008 Q2887465 KB2887465 January 26, 2021
- 2884888 FIX: Unable to click OK or Cancel in the query designer in BIDS 2008 or in SQL Server 2008 Report Builder Q2884888 KB2884888 January 26, 2021
- 2880350 Cumulative update package 13 for SQL Server 2008 SP3 Q2880350 KB2880350 January 26, 2021
- 2878968 FIX: Nonclustered index corruption may occur when you run a complex UPDATE statement together with a NOLOCK hint against a table in SQL Server Q2878968 KB2878968 January 26, 2021
- 2877204 FIX: Error 8985 when you run the "dbcc shrinkfile" statement by using the logical name of a file in SQL Server 2008 R2 or SQL Server 2008 Q2877204 KB2877204 January 26, 2021
- 2863205 Cumulative update package 12 for SQL Server 2008 SP3 Q2863205 KB2863205 January 26, 2021
- 2861939 FIX: Cannot uninstall, repair, add new features to, or add a new instance to SQL Server 2008 or SQL Server 2008 R2 in Windows 8 Q2861939 KB2861939 January 26, 2021
- 2859713 FIX: "The decryption key is incorrect" error when you open a symmetric key that is encrypted by an asymmetric key in SQL Server 2008, SQL Server 2012 or SQL Server 2008 R2 Q2859713 KB2859713 January 26, 2021
- 2844196 FIX: Not all results are returned when you perform a full-text search in SQL Server 2008 or SQL Server 2008 R2 Q2844196 KB2844196 January 26, 2021
- 2834048 Cumulative update package 11 for SQL Server 2008 SP3 Q2834048 KB2834048 January 26, 2021
- 2828205 FIX: SQL Server may freeze when an instance of SQL Server 2012, SQL Server 2008 or SQL Server 2008 R2 is shut down Q2828205 KB2828205 January 26, 2021
- 2821836 FIX: Incorrect result when you run an MDX query that returns multiple calculated members in SSAS 2008, SSAS 2012 or SSAS 2008 R2 Q2821836 KB2821836 January 26, 2021
- 2820952 FIX: Query on a role-playing dimension returns incorrect results in SSAS 2008, SSAS 2012 or SSAS 2008 R2 Q2820952 KB2820952 January 26, 2021
- 2819662 FIX: SQL Server performance issues in NUMA environments Q2819662 KB2819662 January 26, 2021
- 2814783 Cumulative update package 10 for SQL Server 2008 Service Pack 3 Q2814783 KB2814783 January 26, 2021
- 2812884 FIX: Index size increases significantly after you rebuild the index online and the RCSI is enabled in SQL Server 2008 or in SQL Server 2008 R2 Q2812884 KB2812884 January 26, 2021
- 2809431 FIX: Heap corruption occurs when an MDX error message is generated in SSAS 2008, SSAS 2008 R2 or SSAS 2012 Q2809431 KB2809431 January 26, 2021
- 2803994 FIX: Data corruption occurs when LOB data is loaded into a Transact-SQL variable in SQL Server 2008 R2, SQL Server 2012 or SQL Server 2008 Q2803994 KB2803994 January 26, 2021
- 2803799 FIX: A query that runs against a DMV enters an infinite loop in SQL Server 2008 R2, SQL Server 2008 or SQL Server 2012 Q2803799 KB2803799 January 26, 2021
- 2802244 FIX: Installation or upgrade process fails when you install or upgrade a SQL Server 2008 clustered instance on mount points Q2802244 KB2802244 January 26, 2021
- 2799883 Cumulative update package 9 for SQL Server 2008 Service Pack 3 Q2799883 KB2799883 January 26, 2021
- 2791745 FIX: Access violation when you run a query that contains many constant values in an IN clause in SQL Server 2008 or in SQL Server 2012 Q2791745 KB2791745 January 26, 2021
- 2780146 FIX: "Incorrect syntax near 'IDENTITY_VALUE'" error when you try to decrypt data that is migrated from another database in SQL Server 2008 R2, SQL Server 2012 or in SQL Server 2008 Q2780146 KB2780146 January 26, 2021
- 2778088 FIX: Memory leak if you enable the AUTO_UPDATE_STATISTICS_ASYNC statistics option in SQL Server 2008, in SQL Server 2012 or in SQL Server 2008 R2 Q2778088 KB2778088 January 26, 2021
- 2771833 Cumulative update package 8 for SQL Server 2008 Service Pack 3 Q2771833 KB2771833 January 26, 2021
- 2770891 FIX: "Non-yielding Scheduler" error message when you insert a record that contains large object (LOB) data into a snapshot database in SQL Server 2008 or in SQL Server 2008 R2 Q2770891 KB2770891 January 26, 2021
- 2770837 FIX: "Windows NT user or group 'Domain_name\User_name' not found" error message when you add a login to a case-sensitive SQL Server 2008 instance or SQL Server 2008 R2 instance Q2770837 KB2770837 January 26, 2021
- 2770635 FIX: Incorrect result when you run an MDX query against an SSAS 2008 R2 or SSAS 2012 database that has multiple data sources Q2770635 KB2770635 January 26, 2021
- 2756471 FIX: Incorrect result is returned when you query an indexed view by using the NOEXPAND hint in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2756471 KB2756471 January 26, 2021
- 2755079 FIX: Changes are not synchronized to subscribers after you change an article filter in a transactional replication publication in SQL Server 2008, in SQL Server 2012 or in SQL Server 2008 R2 Q2755079 KB2755079 January 26, 2021
- 2754301 FIX: Large queries that modify data run slower than expected when many locks accumulate in a SQL Server 2008 R2 or in SQL Server 2012 Q2754301 KB2754301 January 26, 2021
- 2746341 FIX: High CPU usage when you execute an UPDATE statement that includes a "WHERE CURRENT OF <cursor>" clause in SQL Server 2008 Q2746341 KB2746341 January 26, 2021
- 2738350 Cumulative update package 7 for SQL Server 2008 Service Pack 3 Q2738350 KB2738350 January 26, 2021
- 2737161 FIX: Cannot add an article to a publication that is in a database mirroring partnership in SQL Server 2008 or in SQL Server 2008 R2 Q2737161 KB2737161 January 26, 2021
- 2733630 The merge agent may fail during merge replication synchronization in SQL Server Q2733630 KB2733630 January 26, 2021
- 2727322 FIX: Incorrect results are returned when you run a query that uses parallelism in the query execution plan in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2727322 KB2727322 January 26, 2021
- 2723474 FIX: Event ID 322 even though operations are successfully completed in SQL Server 2008 or in SQL Server 2008 R2 Q2723474 KB2723474 January 26, 2021
- 2720940 FIX: Corrupted codes are recorded in Application log or Security log when you audit an instance of SQL Server 2008 that is running on an IA-64 computer Q2720940 KB2720940 January 26, 2021
- 2715953 Cumulative update package 6 for SQL Server 2008 Service Pack 3 Q2715953 KB2715953 January 26, 2021
- 2715512 FIX: Error messages when you use dtexec to execute packages in SSIS 2008, in SSIS 2012 or in SSIS 2008 R2 Q2715512 KB2715512 January 26, 2021
- 2715312 FIX: Errors when you run a query that uses the FOR XML clause in the PATH mode in SQL Server 2008 R2 or in SQL Server 2012 Q2715312 KB2715312 January 26, 2021
- 2713151 FIX: Access violation when you use Database Engine Tuning Advisor to tune a table in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 if you enable the "Include filtered indexes" check box Q2713151 KB2713151 January 26, 2021
- 2711549 FIX: Error is logged when you start SQL Server 2008 or when a client sends a request to the program Q2711549 KB2711549 January 26, 2021
- 2706601 FIX: Series groups in a report are missing when you render the report in SQL Server 2008 Reporting Services or in later versions of Reporting Services Q2706601 KB2706601 January 26, 2021
- 2705236 FIX: An access violation occurs when you run a query that both uses the PIVOT operator and uses parallelism in the query execution plan in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2705236 KB2705236 January 26, 2021
- 2699013 FIX: SQL Server 2012, SQL Server 2008 R2 or SQL Server 2008 stops responding and a "Non-yielding Scheduler" error is logged Q2699013 KB2699013 January 26, 2021
- 2696626 Cumulative update package 5 for SQL Server 2008 Service Pack 3 Q2696626 KB2696626 January 26, 2021
- 2696625 Cumulative update package 10 for SQL Server 2008 Service Pack 2 Q2696625 KB2696625 January 26, 2021
- 2682488 FIX: Backup operation fails in a SQL Server database after you enable change tracking Q2682488 KB2682488 January 26, 2021
- 2680799 FIX: Error message when you perform a full population of a full-text index by using word breakers for Chinese language in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2680799 KB2680799 January 26, 2021
- 2675522 FIX: Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2, in SQL Server 2008 or in SQL Server 2012 Q2675522 KB2675522 January 26, 2021
- 2673997 FIX: "The index data is damaged" error message when you run an MDX query against a dimension or partition in SSAS 2008, in SSAS 2008 R2 or in SSAS 2012 Q2673997 KB2673997 January 26, 2021
- 2673382 Cumulative update package 9 for SQL Server 2008 Service Pack 2 Q2673382 KB2673382 January 26, 2021
- 2673056 FIX: SQL Server Configuration Manager takes a long time to open if many SQL Server 2008 R2 or SQL Server 2012 instances are installed Q2673056 KB2673056 January 26, 2021
- 2671078 FIX: "Attempting to set a non-NULL-able column's value to NULL" error message when you use a MERGE statement in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2671078 KB2671078 January 26, 2021
- 2667742 FIX: "out of memory" error when you use ODBC with SQL Server 2012, SQL Server 2008 R2 or SQL Server 2008 Q2667742 KB2667742 January 26, 2021
- 2665649 FIX: "bufferLen >= colLen" assertion when you run a parallel query in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2665649 KB2665649 January 26, 2021
- 2660646 FIX: Incorrect result is returned when the STUnion() method is called between a geometry instance and a GEOMETRYCOLLECTION instance in a query in SQL Server 2008 Q2660646 KB2660646 January 26, 2021
- 2658474 FIX: Incorrect results when the SqlConnection.GetSchema method retrieves a table’s schema information in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2658474 KB2658474 January 26, 2021
- 2658234 FIX: Unnecessary updates to a subscriber after you reinitialize it if a new article is added to a publication in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2658234 KB2658234 January 26, 2021
- 2658214 FIX: Poor performance when you run a query that contains correlated AND predicates in SQL Server 2008 or in SQL Server 2008 R2 or in SQL Server 2012 Q2658214 KB2658214 January 26, 2021
- 2653857 FIX: You cannot connect to SQL Server by using JDBC Driver for SQL Server after you upgrade to JRE 6 update 29 or a later version Q2653857 KB2653857 January 26, 2021
- 2651629 FIX: Error message when you use DTA to tune one or more queries against a database that contains many objects in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2651629 KB2651629 January 26, 2021
- 2649913 FIX: Performance might decrease when you run a query that uses the sp_cursoropen stored procedure after you upgrade from SQL Server 2005 to SQL Server 2008 or to SQL Server 2008 R2 or to SQL Server 2012 Q2649913 KB2649913 January 26, 2021
- 2648096 Cumulative update package 8 for SQL Server 2008 Service Pack 2 Q2648096 KB2648096 January 26, 2021
- 2645648 FIX: Export procedure fails when you export a 64-bit SSRS 2008 R2 report, SSRS 2012 report or a SSRS 2008 report that contains multiple levels of a document map to the PDF format Q2645648 KB2645648 January 26, 2021
- 2644794 FIX: False assertion error when you try to convert the value from an XML column to an XML variable in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2644794 KB2644794 January 26, 2021
- 2643872 FIX: "HRESULT 0xE06D7363" error message when a client application uses the Microsoft.SqlServer.Types.dll component on a computer that has SQL Server 2008 SP2 installed Q2643872 KB2643872 January 26, 2021
- 2640110 FIX: An sp_execute_policy error if both SQL Server 2008 R2 and SQL Server 2008 are installed Q2640110 KB2640110 January 26, 2021
- 2638448 FIX: Access violation when a query is compiled or recompiled in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2638448 KB2638448 January 26, 2021
- 2635827 FIX: Access violation when you run a DBCC CHECKDB command against a database that contains a table that has a spatial index in SQL Server 2008 or in SQL Server 2008 R2 Q2635827 KB2635827 January 26, 2021
- 2635219 FIX: Non-ASCII data might be lost when you use the SQLBulkCopy class to transfer Non-ASCII data in SQL Server 2008 Q2635219 KB2635219 January 26, 2021
- 2634571 Improvements for the DBCC CHECKDB command may result in faster performance when you use the PHYSICAL_ONLY option Q2634571 KB2634571 January 26, 2021
- 2633143 Cumulative update package 2 for SQL Server 2008 Service Pack 3 Q2633143 KB2633143 January 26, 2021
- 2629969 The SQL Server 2008 builds that were released after SQL Server 2008 SP3 was released Q2629969 KB2629969 January 26, 2021
- 2629456 FIX: Access violation when you insert a record into a new empty partition in SQL Server 2008 or in SQL Server 2008 R2 Q2629456 KB2629456 January 26, 2021
- 2628126 FIX: "Fulltext index error during compression or decompression" error when you create a full-text index in SQL Server 2008 or in SQL Server 2008 R2 if the primary key is set to a BIGINT column Q2628126 KB2628126 January 26, 2021
- 2626246 FIX: Incorrect results when you run a query against a database that has a 90 collation in SQL Server 2008 or in SQL Server 2008 R2 Q2626246 KB2626246 January 26, 2021
- 2625768 FIX: A database page is copied into a database snapshot even though the page is not updated when you perform a read operation in SQL Server 2008 or in SQL Server 2008 R2 Q2625768 KB2625768 January 26, 2021
- 2622823 FIX: ghost_record_count values keep increasing in SQL Server 2008 R2 or in SQL Server 2008 Q2622823 KB2622823 January 26, 2021
- 2619077 FIX: Access violation when a missing task for a background clear operation tries to delete a missing index entry Q2619077 KB2619077 January 26, 2021
- 2618680 FIX: "Not registered correctly" error when you use a pull subscription and the Replication Interactive Conflict Resolver Q2618680 KB2618680 January 26, 2021
- 2618676 FIX: Transaction log backup is created even though the full backup is canceled in SQL Server 2008 or in SQL Server 2008 R2 Q2618676 KB2618676 January 26, 2021
- 2617148 Cumulative update package 7 for SQL Server 2008 Service Pack 2 Q2617148 KB2617148 January 26, 2021
- 2617146 Cumulative update package 1 for SQL Server 2008 Service Pack 3 Q2617146 KB2617146 January 26, 2021
- 2616117 FIX: Incorrect mail profile is displayed in the Alert System page in SQL Server 2008 R2 Q2616117 KB2616117 January 26, 2021
- 2606301 FIX: High memory usage when you run Replication Snapshot Agent in SQL Server 2008 or in SQL Server 2008 R2 Q2606301 KB2606301 January 26, 2021
- 2606211 FIX: Error when a complex MDX query has the NONEMPTY clause in SSAS 2008 R2 or in SSAS 2012 if the WHERE clause has a named set Q2606211 KB2606211 January 26, 2021
- 2605756 FIX: Internal error when you run a MDX query that uses the Descendants function after you upgrade from SSAS 2005 to SSAS 2008, to SSAS 2008 R2 or to SSAS 2012 Q2605756 KB2605756 January 26, 2021
- 2603910 FIX: Backup fails in SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012 if you enable change tracking on the database Q2603910 KB2603910 January 26, 2021
- 2599822 Error message when a business logic handler is used in SQL Server: "The merge process could not store conflict information" Q2599822 KB2599822 January 26, 2021
- 2598903 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2598903 KB2598903 January 26, 2021
- 2591902 FIX: XML data loss when a merge replication encounters a foreign key violation error in SQL Server 2005, in SQL Server 2008, in SQL Server 2008 R2, or in SQL Server 2012 Q2591902 KB2591902 January 26, 2021
- 2591692 FIX: Non-convergence or data loss if a query times out during merge replication in SQL Server 2008 or in SQL Server 2008 R2 Q2591692 KB2591692 January 26, 2021
- 2591461 FIX: "Unexpected error from SE OLEDB interface" error when you run a full-text search query in SQL Server 2008 or in SQL Server 2008 R2 Q2591461 KB2591461 January 26, 2021
- 2590839 FIX: Low CPU spikes at a set interval even without user activity in SQL Server 2008 R2 or in SQL Server 2012 Q2590839 KB2590839 January 26, 2021
- 2589980 FIX: Incorrect results or constraint violation when you run a SELECT or DML statement that uses the row_number function and a parallel execution plan in SQL Server 2008 Q2589980 KB2589980 January 26, 2021
- 2588970 FIX: "Server: Msg 7359" error when you run a distributed query in SQL Server 2008 or in SQL Server 2008 R2 if a schema version is updated more than five times Q2588970 KB2588970 January 26, 2021
- 2588506 FIX: SQLGetDiagRec function does not return errors in SQL Server 2008 or in SQL Server 2008 R2 if more than 2100 query parameters are sent Q2588506 KB2588506 January 26, 2021
- 2588453 FIX: Access violation when DTA runs a query against a table in SQL Server 2008 if an index on a spatial data type column of the table exists Q2588453 KB2588453 January 26, 2021
- 2588050 FIX: Slipstream installation of a SQL Server 2008 or SQL Server 2008 R2 service pack fails when you add new features to the SQL instance if database engine is installed Q2588050 KB2588050 January 26, 2021
- 2587511 FIX: Error when a SQL Server performance condition alert is raised in SQL Server 2008 R2 Q2587511 KB2587511 January 26, 2021
- 2584903 FIX: Data Collector job takes a long time to clear data from an MDW database in SQL Server 2008 or SQL Server 2008 R2 Q2584903 KB2584903 January 26, 2021
- 2583994 FIX: SSIS Checkpoint restores an incorrect variable value for an Execute SQL Task item of a For Loop Container item in SSIS 2008 or in SSIS 2008 R2 if an SSIS package executes again after it fails or stops Q2583994 KB2583994 January 26, 2021
- 2582285 Cumulative update package 6 for SQL Server 2008 Service Pack 2 Q2582285 KB2582285 January 26, 2021
- 2582282 Cumulative update package 16 for SQL Server 2008 Service Pack 1 Q2582282 KB2582282 January 26, 2021
- 2576118 FIX: SSIS does not transfer a Flat File source data if the delimiter consists of two characters in SSIS 2008 R2 or SSIS 2008 Q2576118 KB2576118 January 26, 2021
- 2574973 FIX: Size of a data file that is committed by online page compression is larger than that is committed by offline page compression in SQL Server 2008 or in SQL Server 2008 R2 Q2574973 KB2574973 January 26, 2021
- 2574699 FIX: Database data files might be incorrectly marked as sparse in SQL Server 2008 R2 or in SQL Server 2008 even when the physical files are marked as not sparse in the file system Q2574699 KB2574699 January 26, 2021
- 2569923 FIX: Upload jobs of data collector quickly open and close a large number of TCP ports if the jobs upload data to a MDW database in SQL Server 2008 or in SQL Server 2008 R2 Q2569923 KB2569923 January 26, 2021
- 2567366 FIX: Slow performance when you restore a database in SQL Server 2008 R2, in SQL Server 2008 or in SQL Server 2012 if CDC is enabled Q2567366 KB2567366 January 26, 2021
- 2566163 FIX: Poor performance when table-valued functions use many table variables in SQL Server 2008 R2 or SQL Server 2008 Q2566163 KB2566163 January 26, 2021
- 2565683 FIX: You may receive incorrect results when you run a complex query that contains aggregates functions, join functions, and distinct functions in subqueries in a SQL Server 2008 or SQL Server 2008 R2 environment Q2565683 KB2565683 January 26, 2021
- 2562812 FIX: Error code 17065 when you trace a stored procedure that contains a TVP if the TVP contains a large amount of text or of image data in SQL Server 2008 or in SQL Server 2008 R2 Q2562812 KB2562812 January 26, 2021
- 2555408 Cumulative update package 5 for SQL Server 2008 Service Pack 2 Q2555408 KB2555408 January 26, 2021
- 2554905 FIX: "File error: Data may have been lost" error message when you use Excel 2010 to open an Excel report file that was exported from SSRS 2008, from SSRS 2008 R2 or from SSRS 2012 Q2554905 KB2554905 January 26, 2021
- 2550552 FIX: SQL Server command stops responding when it uses a nonbuffered access path to access a FILESTREAM file in SQL Server 2008 R2 or SQL Server 2008 Q2550552 KB2550552 January 26, 2021
- 2550375 FIX: Deadlock might occur in sys.dm_database_encryption_keys DMV in SQL Server 2008 R2 or in SQL Server 2012 when you run log shipping from many databases to one secondary server Q2550375 KB2550375 January 26, 2021
- 2548593 FIX: Database corruption if data compression enabled on a partitioned table in SQL Server 2008 Q2548593 KB2548593 January 26, 2021
- 2546951 List of issues that are fixed by SQL Server 2008 Service Pack 3 Q2546951 KB2546951 January 26, 2021
- 2546945 List of the bugs that are fixed in SQL Server 2008 Service Pack 3 CTP Q2546945 KB2546945 January 26, 2021
- 2546715 FIX: Non-convergence when a custom stored procedure propagates data changes for a transactional replication in SQL Server 2008 or in SQL Server 2008 R2 Q2546715 KB2546715 January 26, 2021
- 2545989 FIX: "A time-out occurred while waiting for buffer latch" error when many transactions concurrently update a database in SQL Server 2008 R2 or in SQL Server 2008 if the database uses the snapshot isolation level Q2545989 KB2545989 January 26, 2021
- 2544983 FIX: "'Databaseproperty' is not a recognized built-in function name" error when you replicate a SQL Server 2008 or a SQL Server 2008 R2 transactional publication in SQL Server "Denali" Q2544983 KB2544983 January 26, 2021
- 2543687 FIX: Errors when a client application sends an attention signal to SQL Server 2008 or SQL Server 2008 R2 Q2543687 KB2543687 January 26, 2021
- 2543684 FIX: STRelate method incorrectly returns "1" when the two geometry instances are disjointed in SQL Server 2008 Q2543684 KB2543684 January 26, 2021
- 2543217 Reports and schedules are deleted from the report server database if SQL Server 2008 or SQL Server 2008 R2 Reporting Services cannot communicate with the SharePoint object model Q2543217 KB2543217 January 26, 2021
- 2542225 FIX: Assertion failure or other issues occur when you run a DML query against a table or view that has two indexes in SQL Server 2008 or in SQL Server 2008 R2 Q2542225 KB2542225 January 26, 2021
- 2539378 FIX: Replmerg.exe crashes when it enumerates changes to a statement in SQL Server if the stored procedure contains more than 4,000 characters Q2539378 KB2539378 January 26, 2021
- 2537973 FIX: Nested viewer incorrectly appears in Report Manager when you perform a search in an SSRS 2008 report in Internet Explorer 9.0 Q2537973 KB2537973 January 26, 2021
- 2537467 FIX: You cannot use SQL Server Management Objects (SMO) to transfer data from a table in SQL Server 2008 or in SQL Server 2008 R2 Q2537467 KB2537467 January 26, 2021
- 2536225 FIX: CLR stored procedure returns NULL after it is recompiled in SQL Server 2008 R2 or in SQL Server 2008 Q2536225 KB2536225 January 26, 2021
- 2535705 FIX: An access violation occurs when you restore a database and run the sp_replcounters stored procedure at the same time on a server that is running SQL Server 2008 or SQL Server 2008 R2 Q2535705 KB2535705 January 26, 2021
- 2532079 FIX: DML statements do not run on some columns in a table after you enable CDC on some other columns in SQL Server 2008 R2 Q2532079 KB2532079 January 26, 2021
- 2530921 FIX: Incorrect results when you run an INSERT SELECT UNION ALL statement in SQL Server 2008 or in SQL Server 2008 R2 Q2530921 KB2530921 January 26, 2021
- 2527187 Cumulative update package 14 for SQL Server 2008 Service Pack 1 Q2527187 KB2527187 January 26, 2021
- 2527180 Cumulative update package 4 for SQL Server 2008 Service Pack 2 Q2527180 KB2527180 January 26, 2021
- 2526959 FIX: Application performance issue when a query references temporary tables that are created in a session in SQL Server 2008 and in SQL Server 2008 R2 Q2526959 KB2526959 January 26, 2021
- 2526552 FIX: SQL Server Browser service periodically does not respond to incoming requests Q2526552 KB2526552 January 26, 2021
- 2525665 FIX: SQL Server 2008 BIDS stops responding when you stop debugging a SSIS 2008 or a SSIS 2008 R2 package Q2525665 KB2525665 January 26, 2021
- 2525165 FIX: Error message "ORA-01722: invalid number" when you replicate a table to an Oracle server subscriber in SQL Server 2008 or in SQL Server 2008 R2 if a varchar (max) column of the table contains a long value record Q2525165 KB2525165 January 26, 2021
- 2524743 FIX: Recovery takes longer than expected for a database in a SQL Server 2008 or in a SQL Server 2008 R2 environment Q2524743 KB2524743 January 26, 2021
- 2522893 FIX: A backup operation on a SQL Server 2008 or SQL Server 2008 R2 database fails if you enable change tracking on this database Q2522893 KB2522893 January 26, 2021
- 2520808 FIX: Non-yielding scheduler error when you run a query that uses a TVP in SQL Server 2008 or in SQL Server 2008 R2 if SQL Profiler or SQL Server Extended Events is used Q2520808 KB2520808 January 26, 2021
- 2519638 FIX: Error 6512 when you run the sp_addsubscription stored procedure if the "@sync_type" parameter is set to "replication support only" in SQL Server 2008 or in SQL Server 2008 R2 Q2519638 KB2519638 January 26, 2021
- 2519358 FIX: "The integer value is out of range" error when you pass a bigint value as the last_sync_version argument of the CHANGETABLE function in SQL Server 2008 or in SQL Server 2008 R2 Q2519358 KB2519358 January 26, 2021
- 2518306 FIX: MDX query returns incorrect results in SSAS 2008, in SSAS 2008 R2, or in SSAS 2012 if the data cache is not populated Q2518306 KB2518306 January 26, 2021
- 2515286 FIX: "There is no function '{urn:schemas-microsoft-com:xml-sql}:variable()" error for an XQuery query that updates the value of an XML column in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2515286 KB2515286 January 26, 2021
- 2511963 FIX: Query stops responding in SQL Server 2008 or in SQL Server 2008 R2 if the query alters or stops an Extended Events session Q2511963 KB2511963 January 26, 2021
- 2511151 FIX: Column of a Flat File source is not imported if the next column data is one byte longer than the output column width in SSIS 2005, SSIS 2008 or in SSIS 2008 R2 Q2511151 KB2511151 January 26, 2021
- 2510668 You can now use Package Installation Wizard (Dtsinstall.exe) to run the deployment manifest file of an SSIS package when SSIS 2008 or SSIS 2008 R2 is not installed Q2510668 KB2510668 January 26, 2021
- 2506795 FIX: "Insufficient data for an Image" error when you open a .pdf file that is exported from a SQL Server 2008 Reporting Services or SQL Server 2008 R2 Reporting Services environment Q2506795 KB2506795 January 26, 2021
- 2506235 FIX: An access violation may occur when a database is enabled for Transparent Database Encryption in SQL Server 2008 or in SQL Server 2008 R2 Q2506235 KB2506235 January 26, 2021
- 2504090 FIX: Access violation or incorrect result when you insert data into or update a new partition of a partitioned table in SQL Server 2008 R2, SQL Server 2012 or SQL Server 2008 Q2504090 KB2504090 January 26, 2021
- 2499023 FIX: Incorrect results when a complex update query uses the JOIN operator in an execution plan in SQL Server 2008 or in SQL Server 2008 R2 Q2499023 KB2499023 January 26, 2021
- 2498818 FIX: Error 7359 when you run a query against a user-defined function or a view that uses a synonym on a linked server in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Q2498818 KB2498818 January 26, 2021
- 2498796 FIX: An access violation may occur when you update the statistics of a table after you enable and then disable conflict detection on a table in in SQL Server 2008 or in SQL Server 2008 R2 Q2498796 KB2498796 January 26, 2021
- 2498535 Cumulative update package 3 for SQL Server 2008 Service Pack 2 Q2498535 KB2498535 January 26, 2021
- 2497673 Cumulative update package 13 for SQL Server 2008 Service Pack 1 Q2497673 KB2497673 January 26, 2021
- 2497575 FIX: "Error: 18210, Severity: 16, State: 1" error when an application tries to use VDI to back up some data in a SQL Server 2008 or SQL Server 2008 R2 instance Q2497575 KB2497575 January 26, 2021
- 2496375 FIX: "Could not open global shared memory to communicate with performance DLL" warning when you run an SSIS 2008 or SSIS 2008 R2 package on a computer that is running Windows XP Q2496375 KB2496375 January 26, 2021
- 2492027 The reports that are generated in SSRS 2008 R2 Report Manager are not compliant with Section 508 standards Q2492027 KB2492027 January 26, 2021
- 2491510 FIX:A query that has a CONTAINS predicate in a WHERE clause takes a long time to compile in SQL Server 2008 or SQL Server 2008 R2 Q2491510 KB2491510 January 26, 2021
- 2491214 "Non-yielding Scheduler" error and SQL Server 2008 or SQL Server 2008 R2 stops responding intermittently in Windows Server 2008 or in Windows Server 2008 R2 Q2491214 KB2491214 January 26, 2021
- 2491210 FIX: Maintenance plan does not back up a database that is set to AUTO_CLOSE, RESTORING, or STANDBY in SQL Server 2008 or in SQL Server 2008 R2 Q2491210 KB2491210 January 26, 2021
- 2490920 FIX: "Msg 2601, Level 14, State 1, Line 1 Cannot insert duplicate key row" error when you run the ALTER PARTITION FUNCTION statement to split or merge a partition range in SQL Server 2005 or in SQL Server 2008 Q2490920 KB2490920 January 26, 2021
- 2489667 FIX: SQL Server Agent job runs incorrectly if it is scheduled to run every hour on the last day of every week or month in SQL Server 2005 or in SQL Server 2008 or in SQL Server 2008 R2 Q2489667 KB2489667 January 26, 2021
- 2487231 "RESTORE DATABASE is terminating abnormally" error message when you perform a full backup of a database in SQL Server 2008 R2 Q2487231 KB2487231 January 26, 2021
- 2484392 FIX: "xact_seqno" column in the "MSrepl_errors" table does not record a skipped row in SQL Server 2008 or in SQL Server 2008 R2 if you use the "-SkipErrors" parameter in the Distribution Agent Q2484392 KB2484392 January 26, 2021
- 2482977 FIX: 10061 Winsock error code occurs when an application uses the extended OLE DB initialization properties for the SQL Server Native Client 10.0 OLE DB provider in the connection string Q2482977 KB2482977 January 26, 2021
- 2481274 FIX: A query that uses the DATEDIFF function may run slowly in SQL Server 2005 or in SQL Server 2008 or in SQL Server 2008 R2 Q2481274 KB2481274 January 26, 2021
- 2478514 FIX: "The merge process could not access row data" error occurs when the Merge Agent stops, and rows are set to 4 in the genstatus column in the msmerge_genhistory system table Q2478514 KB2478514 January 26, 2021
- 2476322 FIX: A common table expression-based query that uses the CHANGETABLE function runs very slowly in SQL Server 2008 Service Pack 1 or SQL Server 2008 R2 Q2476322 KB2476322 January 26, 2021
- 2465092 FIX: "SQLSTATE: HY000" error occurs when you use Microsoft OLE DB Provider for DB2 v3 to load data in SSIS by using a FastLoad option Q2465092 KB2465092 January 26, 2021
- 2463682 FIX: Database with transparent data encryption enabled is marked as "suspect" if the server certificate is dropped in SQL Server 2008 or in SQL Server 2008 R2 Q2463682 KB2463682 January 26, 2021
- 2459742 FIX: The columns do not replicate correctly when you use Web synchronization for a merge replication in SQL Server 2008 if a column contains a NULL value Q2459742 KB2459742 January 26, 2021
- 2459027 FIX: "Index was outside the bounds of the array" SMO error message when you connect to a SQL Server code-named 'Denali' CTP1 Database Engine instance in SSMS 2008 R2 and in SSMS 2008 Q2459027 KB2459027 January 26, 2021
- 2455614 FIX: BIDS for SQL Server 2008 or SQL Server 2008 R2 responds very slowly when you design an MDX query that has many query parameters Q2455614 KB2455614 January 26, 2021
- 2451540 FIX: Poor performance may occur when you execute a query that contains multiple self-join operations on the same column in SQL Server 2005, in SQL Server 2008 and in SQL Server 2008 R2 Q2451540 KB2451540 January 26, 2021
- 2448991 FIX: The variables of an SSIS 2008, SSIS 2008 R2 or SSIS 2005 package are evaluated incorrectly when you run the package in parallel Q2448991 KB2448991 January 26, 2021
- 2448971 FIX: The locks of a table are not escalated when you insert many rows into a table in SQL Server 2008 or in SQL Server 2008 R2 Q2448971 KB2448971 January 26, 2021
- 2446860 FIX: The sys.syscommittab system table is not cleaned up after the retention period for change tracking in SQL Server 2008 Q2446860 KB2446860 January 26, 2021
- 2445812 FIX: A column that uses the DATETIME data type does not replicate to an Oracle subscriber by using a transactional replication in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2012 Q2445812 KB2445812 January 26, 2021
- 2444085 FIX: "Transaction is already aborted (WinMgmt)" error when you run DTC transactions from BizTalk Server 2009 to SQL Server 2008 or SQL Server 2008 R2 if event notifications are enabled Q2444085 KB2444085 January 26, 2021
- 2435844 FIX: A SQL Server Agent job incorrectly runs after the specified end date in SQL Server 2008 and in SQL Server 2008 R2 Q2435844 KB2435844 January 26, 2021
- 2435404 FIX: Computer stops responding when you create a database that contains a FILESTREAM filegroup in SQL Server 2008 or in SQL Server 2008 R2 if a third-party mini-filter driver is installed Q2435404 KB2435404 January 26, 2021
- 2433265 FIX: You may receive an incorrect result when you run a query that uses the ROW_NUMBER function together with a left outer join in SQL Server 2008 and SQL Server 2008 R2 Q2433265 KB2433265 January 26, 2021
- 2432235 FIX: High memory consumption may occur when you rebuild a single partition of the heap table in SQL Server 2008 or SQL Server 2008 R2 Q2432235 KB2432235 January 26, 2021
- 2428916 FIX: A performance condition alert is incorrectly raised in SQL Server 2008 or SQL Server 2008 R2 if a case-sensitive collation is configured Q2428916 KB2428916 January 26, 2021
- 2421014 FIX: "A severe error occurred on the current command" error message when you use the Freetexttable or the Containstable function on an indexed view in a CTE query in SQL Server 2008 or in SQL Server 2008 R2 Q2421014 KB2421014 January 26, 2021
- 2413430 FIX: "Cannot locate version record and page is not allocated" error message occurs when you rebuild an index by using the ONLINE option in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q2413430 KB2413430 January 26, 2021
- 2412203 "Bulk Insert with another outstanding result set should be run with XACT_ABORT on" error message may occur when you run a DTC or MARS transaction in SQL Server 2008 or SQL Server 2008 R2 Q2412203 KB2412203 January 26, 2021
- 2407172 FIX: An exception occurs before the error output for invalid data of an "XML Source" task is redirected in SSIS 2005, SSIS 2008 or SSIS 2008R2 Q2407172 KB2407172 January 26, 2021
- 2406666 FIX: "[Teradata Database] [3737]" error when you click "Count" in the Aggregation Design Wizard in SSAS 2008, in SSAS 2012 or in SSAS 2008 R2 Q2406666 KB2406666 January 26, 2021
- 2404865 FIX: High CPU usage when you run a SQL Server Agent job in SQL Server 2008 or SQL Server 2008 R2 if a column of a dynamic SELECT statement has a value that is many characters long Q2404865 KB2404865 January 26, 2021
- 2403218 FIX: Database mirroring session is suspended in SQL Server 2005 and in SQL Server 2008 and in SQL Server 2008 R2 if the High-performance (asynchronous) mode is used Q2403218 KB2403218 January 26, 2021
- 2397020 FIX: "Access is denied. [0x80070005]" error message occurs in SSCM when you try to change the password of an account of SQL Server 2008 or SQL Server 2008 R2 in Windows Vista or in a later version of Windows Q2397020 KB2397020 January 26, 2021
- 2387686 FIX: "A MOF syntax error occurred" error message occurs when you try to install SQL Server 2008 or SQL Server 2008 R2 Q2387686 KB2387686 January 26, 2021
- 2384766 FIX: The ANSI_NULLS property of an indexed view is changed to FALSE after the indexed view is replicated to the subscription database in SQL Server 2008 or in SQL Server 2008 R2 Q2384766 KB2384766 January 26, 2021
- 2380435 FIX: The query plan for a stored procedure is not cached if the stored procedure uses a BLOB variable and the variable is used in a string function in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 Q2380435 KB2380435 January 26, 2021
- 2380361 FIX: Error message when you run the "sp_createstats" stored procedure in SQL Server 2008 or in SQL Server 2008 R2 if the table contains a nondeterministic computed column Q2380361 KB2380361 January 26, 2021
- 2379466 FIX: "0x84B10001" error code, SQL Server 2008 or SQL Server 2008 R2 Setup failure, and an unhandled exception occur when you run SQL Server 2008 or SQL Server 2008 R2 Setup Q2379466 KB2379466 January 26, 2021
- 2357947 FIX: Incorrect order of the characters and numbers when you use OLE DB Provider for DB2 version 3.0 if the column contains some Hebrew characters Q2357947 KB2357947 January 26, 2021
- 2352413 FIX: Query failure and an "Invalid column name" error message occur when you run a linked server query to another instance of SQL Server 2008 or SQL Server 2008 R2 Q2352413 KB2352413 January 26, 2021
- 2344600 FIX: "Non-yielding Scheduler" error may occur when you use the CONTAINSTABLE function together with many OR and AND predicates in SQL Server 2008 or in SQL Server 2008 R2 Q2344600 KB2344600 January 26, 2021
- 2316135 FIX: "An unexpected exception occurred" internal error and heap corruption occurs when you run a MDX query that is generated by third-party software in SSAS 2008 Q2316135 KB2316135 January 26, 2021
- 2306162 FIX: Poor performance and some occasional non-yielding scheduler errors occur when you create a complex view that references a large amount of nested views or tables in SQL Server 2008 or in SQL Server 2008 R2 Q2306162 KB2306162 January 26, 2021
- 2300689 FIX: You cannot restore a backup of a database on another instance of SQL Server if you disable transparent data encryption before you create the backup in SQL Server 2008 or in SQL Server 2008 R2 Q2300689 KB2300689 January 26, 2021
- 2297903 FIX: Event ID 322 is logged when a server audit is output in SQL Server 2008 or SQL Server 2008 R2 Q2297903 KB2297903 January 26, 2021
- 2297709 FIX: An error message may occur when you run a "BULK INSERT" query on a database that uses the "BULK_LOGGED" or "SIMPLE" recovery model in SQL Server Q2297709 KB2297709 January 26, 2021
- 2297308 FIX: "A previous filestream configuration attempt was incomplete" error and an access violation occur when you perform post-setup configuration of the FILESTREAM feature on a SQL Server 2008 or SQL Server 2008 R2 failover cluster Q2297308 KB2297308 January 26, 2021
- 2295878 FIX: LOB pages that are allocated in a failed INSERT statement may not be reclaimed after you apply SQL Server 2005 SP3, SQL Server 2005 SP4, SQL Server 2008 SP1 or SQL Server 2008 R2 Q2295878 KB2295878 January 26, 2021
- 2295869 FIX: An unresolved deadlock occurs when a database is recovered in SQL Server 2005, SQL Server 2008, or in SQL Server 2008 R2 Q2295869 KB2295869 January 26, 2021
- 2295460 Fix: Replication error message when you register a custom resolver to a merge replication in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 if a BIGINT column contains a NULL value Q2295460 KB2295460 January 26, 2021
- 2289254 Cumulative update package 1 for SQL Server 2008 Service Pack 2 Q2289254 KB2289254 January 26, 2021
- 2287990 FIX: The "Derived Column" transformation may produce incorrect results when you run a package in Microsoft SQL Server 2008 or SQL Server 2008 R2 Integration Services Q2287990 KB2287990 January 26, 2021
- 2285711 FIX: A fix is available that improves the manageability of SSMS 2008 R2 to support Spatial Types for SQL Azure Q2285711 KB2285711 January 26, 2021
- 2285068 List of the bugs that are fixed in SQL Server 2008 Service Pack 2 Q2285068 KB2285068 January 26, 2021
- 2283072 FIX: A hotfix is available that enables SQL Server 2008 Reporting Services and SQL Server 2008 R2 Reporting Services to use a 2048-bit RSA key to encrypt a Reporting Services key for FIPS compliancy Q2283072 KB2283072 January 26, 2021
- 2282743 FIX: The special characters are displayed incorrectly in a "TextBox" control of a PDF file when you render a report in SSRS 2008 Q2282743 KB2282743 January 26, 2021
- 2280390 FIX: Error message when you query an XML data type column in an SQL table on a server that is running SQL Server 2008 or SQL Server 2008 R2: "Index was outside the bounds of the array" Q2280390 KB2280390 January 26, 2021
- 2278042 FIX: A derived column transformation may generate incorrect results in SSIS 2008 or in SSIS 2008 R2 when a column is derived both in read-only usage and in read/write usage Q2278042 KB2278042 January 26, 2021
- 2277207 FIX: The value of the "Axis" label appears in each column and the "Gridline Interval" value is not honored after a RDL file is upgraded from SSRS 2005 to SSRS 2008 Q2277207 KB2277207 January 26, 2021
- 2277078 FIX: The TokenAndPermUserStore cache store size continues to grow when you enable a SQL Server audit in SQL Server 2008 R2 and in SQL Server 2008 Q2277078 KB2277078 January 26, 2021
- 2276717 FIX: Error code 1456 when you add a witness to a new database mirroring session that has the same database name as an existing database mirroring session in Microsoft SQL Server 2008 and in Microsoft SQL Server 2008 R2 Q2276717 KB2276717 January 26, 2021
- 2276330 FIX: The "CHANGETABLE" function is slow in SQL Server 2008 and in SQL Server 2008 R2 Q2276330 KB2276330 January 26, 2021
- 2268122 FIX: "User 'guest' does not have permission to run DBCC checkdb for database 'mssqlsystemresource'" error message when you run the DBCC CHECKDB('master') command on a computer that is running SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q2268122 KB2268122 January 26, 2021
- 2261403 FIX: The "SQL Server:SSIS Pipeline 10.0" performance object does not appear in the "Performance object" list while another user accesses some SSIS pipeline counters in SQL Server 2008, in SQL Server 2008 R2 or in SQL Server 2005 Q2261403 KB2261403 January 26, 2021
- 2260502 FIX: Query performance decreases after you upgrade to SQL Server 2008 or SQL Server 2008 R2 from SQL Server 2000 if the query uses a user-defined scalar function Q2260502 KB2260502 January 26, 2021
- 2256829 FIX: A certain number of the last XML columns may not be replicated correctly if you use web synchronization for merge replication in SQL Server 2008 or SQL Server 2008 R2 Q2256829 KB2256829 January 26, 2021
- 2255379 Error message when you run an ADO.NET Framework application to remotely perform read or write operations on FILESTREAM data on a SQL Server 2008 server Q2255379 KB2255379 January 26, 2021
- 2252955 Considerations when using the SQL Server Full-Text search engine for the Japanese language Q2252955 KB2252955 January 26, 2021
- 2214666 FIX: An SSIS package that uses the Unpivot transformation may produce inconsistent results in SQL Server 2008 or SQL Server 2008 R2 Q2214666 KB2214666 January 26, 2021
- 2159286 FIX: The Remote Registry service crashes when an application tries to retrieve performance counter data from an instance of SQL Server on another computer Q2159286 KB2159286 January 26, 2021
- 2152148 FIX: "Internal error: An unexpected exception occurred" error message when you run a Multidimensional Expressions (MDX) query by using time intelligence in Microsoft SQL Server Analysis Services 2008 Q2152148 KB2152148 January 26, 2021
- 2142496 FIX: A SQL Server 2008 R2 or SQL Server 2008 Integration Services package does not run in SQL Server Business Intelligence Development Studio when you use a shared SQL configuration table Q2142496 KB2142496 January 26, 2021
- 2121407 FIX: Error message when you use the sqlcmd utility to execute the Transact-SQL query in SQL Server 2008 and SQL Server 2008 R2 Q2121407 KB2121407 January 26, 2021
- 2028830 FIX: Shared components are installed in the wrong location when you implement a SQL Server 2008 or SQL Server 2012 Failover Cluster installation Q2028830 KB2028830 January 26, 2021
- 2028727 FIX: Column group values are displayed in only the last child row group of the adjacent row groups in SSRS 2008 Q2028727 KB2028727 January 26, 2021
- 983286 FIX: "A connection cannot be made" error message in SSAS 2008 or SSAS 2008 R2 when you try to connect to a database Q983286 KB983286 January 26, 2021
- 982924 FIX: "System.Exception: Win32.ExtTextOut failed; Win32 error:997" error message when the EMF printing renderer is under stress or when you try to print multiple reports at the same time in SSRS 2008 Q982924 KB982924 January 26, 2021
- 982854 FIX: Error "There is insufficient system memory in resource pool 'internal' to run this query" in Microsoft SQL Server Q982854 KB982854 January 26, 2021
- 982512 Microsoft JDBC Driver 2.0 cannot connect to SQL Server 2008 from a FIPS-enabled IBM WebSphere application Q982512 KB982512 January 26, 2021
- 982441 FIX: You receive error 666 when you rebuild an index online on a partition scheme in SQL Server 2008 or SQL Server 2008 R2 Q982441 KB982441 January 26, 2021
- 982376 FIX: A non-yielding scheduler error or an error 8623 occurs when you run a query that contains a large IN clause in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Q982376 KB982376 January 26, 2021
- 981702 Cumulative update package 8 for SQL Server 2008 Service Pack 1 Q981702 KB981702 January 26, 2021
- 981611 FIX: An access violation occurs when you use the COUNT_BIG function and the OVER clause in a query in SQL Server 2008 or SQL Server 2008 R2 Q981611 KB981611 January 26, 2021
- 981108 FIX: Error message when SQL Server 2008 Reporting Services or the SQL Server 2008 database engine is running: "Fatal Execution Engine Error (000006427F44AE16)" or "A fatal error occurred in the .NET Framework common language runtime" Q981108 KB981108 January 26, 2021
- 980849 FIX: You experience high latency for peer-to-peer distribution agents in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2 Q980849 KB980849 January 26, 2021
- 980832 FIX: "A system assertion check has failed" error message when you run a Transaction-SQL query in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2 Q980832 KB980832 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
- 980142 FIX: "Provider Load Failure" error message or the Wmiprvse.exe process stops responding when you use a SQL Server WMI provider to obtain information about SQL Server 2012, SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 services Q980142 KB980142 January 26, 2021
- 979785 FIX: Error message when you use the Script Wizard to generate scripts for stored procedures in SQL Server 2008 or SQL Server 2008 R2 Q979785 KB979785 January 26, 2021
- 979779 FIX: Several problems occur when you use a linked server that was created by the SQL Native Client provider in SQL Server 2008 Q979779 KB979779 January 26, 2021
- 979212 FIX: A DateTime value is replaced by a NULL value when a conflict is resolved by using a custom resolver in Microsoft SQL Server 2005, Microsoft SQL Server 2008 or Microsoft SQL Server 2008 R2 merge replication Q979212 KB979212 January 26, 2021
- 978629 FIX: Error message when you use the system_health Extended Event session to capture a deadlock graph in SQL Server 2008: "Msg 9436: XML parsing: line 54, character 12, end tag does not match start tag" Q978629 KB978629 January 26, 2021
- 977190 The SSIS 2008 runtime process crashes when you run the SSIS 2008 package under a low-memory condition Q977190 KB977190 January 26, 2021
- 975977 Cumulative Update Package 5 for SQL Server 2008 Service Pack 1 Q975977 KB975977 January 26, 2021
- 975915 FIX: An arithmetic overflow error occurs intermittently during the "Collect a snapshot of sys.dm_exec_query_stats" phase after you enabled data collector in SQL Server 2008 Q975915 KB975915 January 26, 2021
- 975752 FIX: "ConnConnectAndSetCryptoForXpstar failed (0)"error message occurs when you try to start the SQL Server Agent service from a Remote Desktop session in SQL Server 2008 or in SQL Server 2008 R2 Q975752 KB975752 January 26, 2021
- 975374 FIX: The check phase of the WMI service fails when you set up a SQL Server 2008 cluster Q975374 KB975374 January 26, 2021
- 974795 A package step that references the Microsoft Dynamics NAV 4.0 NODBC data source cannot be marked as "Complete" if you use the NODBC driver in Microsoft SQL Server 2008 SSIS packages Q974795 KB974795 January 26, 2021
- 974660 FIX: You receive out-of-memory error messages when you use merge replication with Web synchronization in SQL Server 2005 or in SQL Server 2008 Q974660 KB974660 January 26, 2021
- 974076 FIX: Error message when you use the DTExec.exe or DTExecUi.exe utility to run a SQL Server 2008 Integration Services package by specifying a configuration file: “The package path referenced an object that cannot be found” Q974076 KB974076 January 26, 2021
- 973602 Cumulative update package 4 for SQL Server 2008 Service Pack 1 Q973602 KB973602 January 26, 2021
- 973524 FIX: The execution of the xp_readerrorlog command in SQL Server 2005 and in SQL Server 2008 stops responding and the usage of the CPU that is running the command increases to 100 percent Q973524 KB973524 January 26, 2021
- 971622 FIX: The memory usage of a SQL Server service increases quickly when you run a query that uses a linked server in SQL Server 2005 or in SQL Server 2008 Q971622 KB971622 January 26, 2021
- 971491 Cumulative update package 3 for SQL Server 2008 Service Pack 1 Q971491 KB971491 January 26, 2021
- 971051 FIX: Error message when you run a SQL Server 2008-based application that calls the SQLBindParameter function: "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect" Q971051 KB971051 January 26, 2021
- 970365 The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released Q970365 KB970365 January 26, 2021
- 970315 Cumulative update package 2 for SQL Server 2008 Service Pack 1 Q970315 KB970315 January 26, 2021
- 970070 Support for Locked Pages on SQL Server Standard Edition (64-bit) systems Q970070 KB970070 January 26, 2021
- 969845 FIX: Error message when you run a SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 Integration Services package (SSIS) after you install the .NET Framework 2.0 SP2 or the .NET Framework 3.5 SP1: "ADO NET Source [1424]" Q969845 KB969845 January 26, 2021
- 969793 FIX: Error message when you click the Columns tab in OLE DB Source Editor in SQL Server 2008 Integration Services: "Error at Data Flow Task [OLE DB Source [1]]: SSIS Error Code DTS_E_OLEDBERROR" Q969793 KB969793 January 26, 2021
- 969099 Cumulative update package 1 for SQL Server 2008 Service Pack 1 Q969099 KB969099 January 26, 2021
- 968834 FIX: Error message when you send an e-mail by using Database Mail in SQL Server 2005 or in SQL Server 2008: "The operation has timed out" Q968834 KB968834 January 26, 2021
- 968830 FIX: An incorrect version is displayed on the Instance Selection page when you use SQL Server 2008 Setup to upgrade an instance of SQL Server 2008 Q968830 KB968830 January 26, 2021
- 968382 How to obtain the latest service pack for SQL Server 2008 Q968382 KB968382 January 26, 2021
- 968369 List of the bugs that are fixed in SQL Server 2008 Service Pack 1 Q968369 KB968369 January 26, 2021
- 968215 FIX: Error message when you try to bulk insert data into a table that contains a DATE type column that uses a US date format in SQL Server 2008 or in SQL Server 2008 R2: "Bulk load data conversion error" Q968215 KB968215 January 26, 2021
- 967749 FIX: Error message when you view a SQL Server 2008 Reporting Services report that contains more than one subreport: "Error: Subreport could not be shown" Q967749 KB967749 January 26, 2021
- 967552 FIX: SQL Server 2008 Database Auditing shows query criteria as a parameterized value instead of the actual record Q967552 KB967552 January 26, 2021
- 963659 FIX: You receive error messages when you perform a population for a large full-text index in SQL Server 2008 or in SQL Server 2008 R2 Q963659 KB963659 January 26, 2021
- 961126 FIX: Error message when you run a maintenance plan in SQL Server 2008: "The SQL Server Execute Package Utility requires Integration Services to be installed" Q961126 KB961126 January 26, 2021
- 960770 FIX: You receive error 605 and error 824 when you run a query that inserts data into a temporary table in SQL Server Q960770 KB960770 January 26, 2021
- 960484 Cumulative update package 3 for SQL Server 2008 Q960484 KB960484 January 26, 2021
- 958778 FIX: The default instance name is set incorrectly to SQLEXPRESS when you install SQL Server 2008 Express Q958778 KB958778 January 26, 2021
- 958745 FIX: Error message when you try to run or preview a very large report in Microsoft SQL Server 2008 Reporting Services: "Exception of type System.OutOfMemoryException was thrown" Q958745 KB958745 January 26, 2021
- 958611 FIX: You may receive incorrect results when you run a query that references three or more tables in the FROM clause in SQL Server 2008 Q958611 KB958611 January 26, 2021
- 958186 Cumulative update package 2 for SQL Server 2008 Q958186 KB958186 January 26, 2021
- 958006 FIX: The size of the error log file for the SQL Server 2008 error log file grows very quickly when query notifications are created and destroyed in a high ratio Q958006 KB958006 January 26, 2021
- 957823 FIX: The clustered index table may take longer than you expect to be rebuilt when you use the ALTER INDEX REBUILD statement in SQL Server Q957823 KB957823 January 26, 2021
- 957459 FIX: Error message when you try to add a second node to a SQL Server 2008 failover cluster: "The current SKU is invalid" Q957459 KB957459 January 26, 2021
- 957453 FIX: When you install SQL Server 2008, the installation fails, and the "Attributes do not match" error message is logged in the Summary.txt file Q957453 KB957453 January 26, 2021
- 956718 FIX: A MERGE statement may not enforce a foreign key constraint when the statement updates a unique key column that is not part of a clustering key and there is a single row as the update source in SQL Server 2008 Q956718 KB956718 January 26, 2021
- 956717 Cumulative update package 1 for SQL Server 2008 Q956717 KB956717 January 26, 2021
- 954950 FIX: Error message when you run a distributed query in SQL Server 2005 or SQL Server 2008: "OLE DB provider 'SQLNCLI' for linked server '<Linked Server>' returned message 'No transaction is active'" Q954950 KB954950 January 26, 2021
- 942712 FIX: The W3WP.exe process of Internet Information Services stops unexpectedly when you configure a merge replication that uses Web synchronization in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 Q942712 KB942712 January 26, 2021
- 930283 FIX: You receive error 1456 when you add a witness to a database mirroring session and the database name is the same as an existing database mirroring session in SQL Server 2005 or SQL Server 2008 Q930283 KB930283 January 26, 2021
- 926292 FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2008, the result is still returned in random order Q926292 KB926292 January 26, 2021
- 922578 FIX: Lots of messages that have message ID 19030 and message ID 19031 are logged in SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2 Errorlog file when you use SQL Server Profile in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2 Q922578 KB922578 January 26, 2021
- 897284 Diagnostics in SQL Server help detect stalled and stuck I/O operations Q897284 KB897284 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
- 3146034 Intermittent service terminations occur after you install any SQL Server 2008 or SQL Server 2008 R2 versions from KB3135244 Q3146034 KB3146034 January 25, 2021
- 3137281 FIX: Communication that uses an MD5 hash algorithm fails when you use TLS 1.2 in SQL Server Q3137281 KB3137281 January 25, 2021
- 3065718 MS15-058: Vulnerabilities in SQL Server could allow remote code execution: July 14, 2015 Q3065718 KB3065718 January 25, 2021
- 3045311 MS15-058: Description of the security update for SQL Server 2008 Service Pack 4 GDR: July 14, 2015 Q3045311 KB3045311 January 25, 2021
- 3045308 MS15-058: Description of the security update for SQL Server 2008 Service Pack 4 QFE: July 14, 2015 Q3045308 KB3045308 January 25, 2021
- 3045305 MS15-058: Description of the security update for SQL Server 2008 Service Pack 3 GDR: July 14, 2015 Q3045305 KB3045305 January 25, 2021
- 3045303 MS15-058: Description of the security update for SQL Server 2008 Service Pack 3 QFE: July 14, 2015 Q3045303 KB3045303 January 25, 2021
- 3027860 Error 17066 or 17310 during SQL Server startup Q3027860 KB3027860 January 25, 2021
- 2985455 Kerberos Configuration Manager for SQL Server is available Q2985455 KB2985455 January 25, 2021
- 2984340 MS14-044: Vulnerabilities in SQL Server could allow elevation of privilege: August 12, 2014 Q2984340 KB2984340 January 25, 2021
- 2977322 MS14-044: Description of the security update for SQL Server 2008 Service Pack 3 (QFE): August 12, 2014 Q2977322 KB2977322 January 25, 2021
- 2977321 MS14-044: Description of the security update for SQL Server 2008 SP3 (GDR): August 12, 2014 Q2977321 KB2977321 January 25, 2021
- 2974455 DBCC CHECKDB behavior when the SQL Server database is located on an ReFS volume Q2974455 KB2974455 January 25, 2021
- 2926557 SQL Server VDI backup and restore operations require Sysadmin privileges Q2926557 KB2926557 January 25, 2021
- 2882905 A 9017 informational message is logged when you start an instance of SQL Server or restore or attach a database Q2882905 KB2882905 January 25, 2021
- 2869522 The .NET Framework 4.x assemblies are not supported in SQL Server Reporting Services Q2869522 KB2869522 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
- 2830722 FIX: Access violation when you use a SQL profiler to trace an RPC event class in SQL Server 2008 or SQL Server 2008 R2 Q2830722 KB2830722 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
- 2729953 You may encounter a 'result == LCK_OK' assertion on a SQL Server mirror server Q2729953 KB2729953 January 25, 2021
- 2666213 A TDE-enabled database may not recover in SQL Server 2008 or in SQL Server 2008 R2 Q2666213 KB2666213 January 25, 2021
- 2656988 How to enable the CHECKSUM option if backup utilities do not expose the option Q2656988 KB2656988 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
- 2547273 You cannot add or remove features to a SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012 failover cluster Q2547273 KB2547273 January 25, 2021
- 2543893 MS11-049: Vulnerability in the Microsoft XML Editor could allow information disclosure: June 14, 2011 Q2543893 KB2543893 January 25, 2021
- 2523744 The transaction log may grow without a log backup for a database using the FULL recovery model Q2523744 KB2523744 January 25, 2021
- 2509302 A database transaction log continues to grow after you upgrade to SQL Server 2012, SQL Server 2008 R2 SP1, SQL Server 2008 SP2 or SQL Server 2008 SP3 Q2509302 KB2509302 January 25, 2021
- 2500042 Error message when you install SQL Server 2008 Service Pack 2 Q2500042 KB2500042 January 25, 2021
- 2494100 MS11-049: Description of the security update for SQL Server 2008 Service Pack 1 QFE: June 14, 2011 Q2494100 KB2494100 January 25, 2021
- 2494096 MS11-049: Description of the security update for SQL Server 2008 Service Pack 1 GDR: June 14, 2011 Q2494096 KB2494096 January 25, 2021
- 2494094 MS11-049: Description of the security update for SQL Server 2008 Service Pack 2 QFE: June 14, 2011 Q2494094 KB2494094 January 25, 2021
- 2494089 MS11-049: Description of the security update for SQL Server 2008 Service Pack 2 GDR: June 14, 2011 Q2494089 KB2494089 January 25, 2021
- 2481773 You get "Error code 64" when accessing Replisapi.dll through ISA server Q2481773 KB2481773 January 25, 2021
- 2407439 You may notice an increased transaction log sizes in SQL Server 2008 and later versions when you perform Index Maintenance Q2407439 KB2407439 January 25, 2021
- 2402659 The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 2 was released Q2402659 KB2402659 January 25, 2021
- 2199576 How to troubleshoot SQL Server lock related problems and errors Q2199576 KB2199576 January 25, 2021
- 2160685 Recommendations and guidelines for setting the AUTO_CLOSE database option in SQL Server Q2160685 KB2160685 January 25, 2021
- 2160663 Recommendations and guidelines for setting the AUTO_SHRINK database option in SQL Server Q2160663 KB2160663 January 25, 2021
- 2160002 Recommendations and guidelines for improving SQL Server FILESTREAM performance Q2160002 KB2160002 January 25, 2021
- 2028436 Database operations take a long time to complete, or they trigger errors when the transaction log has numerous virtual log files Q2028436 KB2028436 January 25, 2021
- 2027550 Recommended MSDTC settings for using Distributed Transactions in SQL Server Q2027550 KB2027550 January 25, 2021
- 979064 Cumulative update package 10 for SQL Server 2008 Q979064 KB979064 January 25, 2021
- 972767 FIX: The SQL Server database engine and SQL Server Reporting Services may consume more power on Windows client computers than expected Q972767 KB972767 January 25, 2021
- 969985 How to install Microsoft Visual Studio 2008 Team Foundation Server on a computer that has SQL Server 2008 Service Pack 1 installed Q969985 KB969985 January 25, 2021
- 926930 Hard disk drive sector-size support boundaries in SQL Server Q926930 KB926930 January 25, 2021
- 923247 Troubleshooting DBCC error 2570 in SQL Server 2005 and later versions Q923247 KB923247 January 25, 2021
- 920093 Tuning options for SQL Server when running in high performance workloads Q920093 KB920093 January 25, 2021
- 819546 SQL Server support for mounted volumes Q819546 KB819546 January 25, 2021
- 811889 How to troubleshoot the "Cannot generate SSPI context" error message Q811889 KB811889 January 25, 2021
- 316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console Q316898 KB316898 January 25, 2021
- 310834 Description of common causes of SQL Server error message 844 or error message 845 Q310834 KB310834 January 25, 2021
- 309422 How to choose antivirus software to run on computers that are running SQL Server Q309422 KB309422 January 25, 2021
- 307487 How to shrink the tempdb database in SQL Server Q307487 KB307487 January 25, 2021
- 307356 How to understand Merge Replication article processing order Q307356 KB307356 January 25, 2021
- 234656 Information about using disk drive caches with SQL Server that every database administrator should know Q234656 KB234656 January 25, 2021
- 200043 PRB: Dashes '-' Ignored in Search with SQL Full-Text and MSIDXS Queries Q200043 KB200043 January 25, 2021
- 86903 Description of caching disk controllers in SQL Server Q86903 KB86903 January 25, 2021
- 2681175 DBCC CHECKDB reports a 2576 error after you drop a BLOB column in SQL Server 2008 or in SQL Server 2008 R2 Q2681175 KB2681175 January 20, 2021
- 2901479 FIX: You experience query failure when you run MDX queries in SSAS 2008 Q2901479 KB2901479 January 14, 2021
- 955784 Can't use the Setup program to modify the failover cluster instance in SSAS Q955784 KB955784 January 14, 2021
- 935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems Q935897 KB935897 January 12, 2021