kbupdate.info ›
Daily Updated!
SQL Server 2008 R2 articles, fixes and updates - Year 2012
Daily Updated!
chronological list: 2023 | ... 2 1 | 2020 | 2019 | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2008
alphabetical list: A B C D E F G H I K L M N O P 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 R2 that have been released in Year 2012. The list is daily updated.
- 2757344 FIX: Business Intelligence Development Studio (BIDS) crashes when you select a WSDL file in SQL Server 2008 R2 Q2757344 KB2757344 December 17, 2012
- 2028584 Database Mail is the preferred method to send mail within SQL Server Q2028584 KB2028584 December 9, 2012
- 2157154 The 'Blocked Process Threshold' configuration does not work as expected for values less than 5 Q2157154 KB2157154 December 5, 2012
- 2712071 You cannot access a PowerPivot workbook as a data source in Excel 2010 Q2712071 KB2712071 December 3, 2012
- 2708027 FIX: "An error has occurred during report processing" error message when you try to preview an SSRS 2008 R2 or SSRS 2012 report after you set the dataset collation to Greek or Greek_100 Q2708027 KB2708027 November 20, 2012
- 2777223 Workbook contains hidden rows and columns when you export reports from SQL Server Reporting Services to Excel Q2777223 KB2777223 November 19, 2012
- 2758393 "Pasting Data Failed" error when you paste HTML-formatted data into PowerPivot Q2758393 KB2758393 November 19, 2012
- 2727217 Distribution Agent reports the transactional replication latency incorrectly in SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012 Q2727217 KB2727217 November 19, 2012
- 2733512 Supported method for reducing the SQL Server 2008 R2 setup media size Q2733512 KB2733512 October 22, 2012
- 2023536 Recommendations and Guidelines for 'max degree of parallelism' configuration option Q2023536 KB2023536 October 17, 2012
- 2707185 FIX: An MDX query in SQL Server 2008 R2 runs very slowly if the query contains nested Crossjoin functions Q2707185 KB2707185 October 15, 2012
- 2754849 MS12-070: Vulnerability in SQL Server could allow elevation of privilege: October 9, 2012 Q2754849 KB2754849 October 9, 2012
- 2716440 MS12-070: Description of the security update for SQL Server 2008 R2 Service Pack 1 GDR: October 9, 2012 Q2716440 KB2716440 October 9, 2012
- 2716439 MS12-070: Description of the security update for SQL Server 2008 R2 Service Pack 1 QFE: October 9, 2012 Q2716439 KB2716439 October 9, 2012
- 2755960 SQL query performance might decrease when the SQL Server Database instance has high index fragmentation Q2755960 KB2755960 September 27, 2012
- 2707015 FIX: rsInternalError error when you export a report that contains a Tablix control in SSRS 2008 R2 or in SSRS 2012 Q2707015 KB2707015 August 29, 2012
- 979778 FIX: You receive an error message when you run a query that uses a parent/child dimension in SSAS 2008 Q979778 KB979778 August 27, 2012
- 2737869 FIX: SQL Server StreamInsight 1.2 installation fails or StreamInsight application does not run if FIPS is enabled Q2737869 KB2737869 August 14, 2012
- 2270849 Error 0x80040e97 occurs when you use integrated full-text search in SQL Server Q2270849 KB2270849 August 14, 2012
- 2157129 Changing the 'max worker threads' configuration of SQL Server Q2157129 KB2157129 August 9, 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
- 2732669 Recommendations and guidelines on dynamically extending SQL Server disk volumes Q2732669 KB2732669 July 28, 2012
- 2735237 "File System Error" error when you refresh a PowerPivot workbook on a SharePoint site Q2735237 KB2735237 July 25, 2012
- 2706551 Error during data refresh in PowerPivot instance of SQL Server 2008 R2 Analysis Services: "Unexpected Error" Q2706551 KB2706551 July 17, 2012
- 2498839 FIX: A memory error occurs when you perform a full process of a dimension in SSAS 2008 R2 or in SSAS 2008 Q2498839 KB2498839 July 16, 2012
- 2664701 Support in SQL Server for custom COM-based conflict resolvers that handle merge replication Q2664701 KB2664701 July 9, 2012
- 2183687 Guidelines for using the TRUSTWORTHY database setting in SQL Server Q2183687 KB2183687 July 9, 2012
- 2137408 SQL Server logs "Msg 833" when I/O delay problems occur Q2137408 KB2137408 July 9, 2012
- 2015757 How to troubleshoot Msg 825 (read retry) in SQL Server Q2015757 KB2015757 July 9, 2012
- 956176 Error message when you try to save a table in SQL Server: "Saving changes is not permitted" Q956176 KB956176 July 9, 2012
- 2295244 FIX: You are still prompted to install an RSClientPrint control in SSRS 2008 or SSRS 2008 R2 Q2295244 KB2295244 July 5, 2012
- 2672888 FIX: Basic attribute hierarchy settings are lost if you reopen a role in a SSAS 2008 R2 project in BIDS Q2672888 KB2672888 June 25, 2012
- 2706518 FIX: The KeepFilesForDays setting does not work in SQL Server 2008 or SQL Server 2008 R2 Reporting Services Q2706518 KB2706518 June 18, 2012
- 2691331 Database deadlocks occur when you try to view an SSRS report in the SharePoint integrated mode after you update a data source Q2691331 KB2691331 June 6, 2012
- 2454053 Use of system filter drivers can lead to SQL Server Database Engine performance degradation and consistency problems Q2454053 KB2454053 June 4, 2012
- 2635199 A format-binding element is ignored in a multidimensional database in SQL Server Q2635199 KB2635199 May 26, 2012
- 2607106 Error message when you use a PowerPivot for Excel workbook as a data source in SQL Server 2008 R2 Analysis Services: "HTTP Error 401" Q2607106 KB2607106 May 25, 2012
- 2598605 A custom SQL Server business logic handler replaces an empty string with an end-of-string character Q2598605 KB2598605 May 22, 2012
- 2585632 Synchronization for SQL Server merge replication fails when an article uses a stored procedure custom conflict resolver Q2585632 KB2585632 May 22, 2012
- 2534352 Cumulative update package 8 for SQL Server 2008 R2 Q2534352 KB2534352 May 22, 2012
- 2504524 FIX: "Bad variable type" or "Type mismatch" error when you run an UPDATE CUBE statement that has a custom weighted allocation formula in SSAS 2008 R2 or in SSAS 2008 Q2504524 KB2504524 May 21, 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
- 2638932 FIX: Error when you run the ProcessUpdate command against a cube that has partitions that use aggregation designs in SSAS 2008 or in SSAS 2008 R2 Q2638932 KB2638932 April 17, 2012
- 2157175 Virtual Address Space (VAS) errors can occur on 32bit SQL Server Editions with a large 'network packet size' configuration Q2157175 KB2157175 April 17, 2012
- 2598510 DateTime values are rounded to the nearest second when a business logic handler is used in SQL Server 2008 or SQL Server 2008 R2 Q2598510 KB2598510 April 16, 2012
- 2661225 FIX: Unable to connect to a data source when you use SQL Server Analysis Services 10.0 OLE DB Provider if you enable the "Automatically detect settings" option in the Connections tab of Internet Explorer Q2661225 KB2661225 April 12, 2012
- 2655789 FIX: Replication Log Reader Agent fails with "18773" and "18805" error messages if you set the 'large value types out of row' table option to ON for the publication article table Q2655789 KB2655789 April 12, 2012
- 2652582 FIX: "Invalid authorization specification" error message when you run the SQL Server 2008 R2 Analysis Services Deployment Wizard by using the SQL Server Authentication mode Q2652582 KB2652582 April 12, 2012
- 2647120 FIX: Incorrect page numbers are displayed when you export a SSRS 2008 R2 report into PDF format Q2647120 KB2647120 April 12, 2012
- 2622668 FIX: Error message when you delete some records in a table on a publisher if the schema name of the table is not "[dbo]" Q2622668 KB2622668 April 12, 2012
- 2160698 Recommendations and Guidelines on Granting Server Permissions to Public role Q2160698 KB2160698 April 4, 2012
- 2202875 Guidelines on securing DTS Packages in SQL Server Q2202875 KB2202875 April 3, 2012
- 2202637 Guidelines on using Tokens in SQL Server Agent Job Steps Q2202637 KB2202637 April 3, 2012
- 2201900 Guidelines on Managing Certificates used in Transparent Data Encryption Q2201900 KB2201900 April 3, 2012
- 2187161 Guidelines on Auditing Login failures in SQL Server. Q2187161 KB2187161 April 3, 2012
- 2186935 Guidelines on revoking Guest user access in a database. Q2186935 KB2186935 April 3, 2012
- 2184138 Guidelines on granting SQL Server sysadmin privileges Q2184138 KB2184138 April 3, 2012
- 2162020 Best Practices in Creating and Managing Symmetric and Asymmetric keys used for Encryption Q2162020 KB2162020 April 3, 2012
- 2160741 Best Practices in Configuring SQL Server Agent Proxy account. Q2160741 KB2160741 April 3, 2012
- 2160720 Guidelines on choosing Service Accounts for SQL Server Services. Q2160720 KB2160720 April 3, 2012
- 2146315 Recommended configuration for Verbose Logging in Reporting Services Q2146315 KB2146315 April 3, 2012
- 2146062 Required configuration for Extended Protection in Reporting Services Q2146062 KB2146062 April 3, 2012
- 2145909 Recommendations for configuring HTTP Logging within Reporting Services Q2145909 KB2145909 April 3, 2012
- 2145506 Recommendations for configuring Kerberos with Reporting Services Q2145506 KB2145506 April 3, 2012
- 2033590 SQL Server records the date/time of the most recent database consistency check with no errors Q2033590 KB2033590 April 3, 2012
- 2026108 How to troubleshoot collation conflict errors when executing queries that involve columns with different collations Q2026108 KB2026108 April 3, 2012
- 2023571 Recommendations and Guidelines on configuring disk partitions for SQL Server Q2023571 KB2023571 April 3, 2012
- 2160691 Recommended settings for the lightweight pooling configuration option in SQL Server Q2160691 KB2160691 April 2, 2012
- 2160570 How to use the default system_health extended event session to troubleshoot SQL Server problems Q2160570 KB2160570 April 2, 2012
- 2157114 The 'affinity mask' and 'affinity I/O mask' configuration should not conflict Q2157114 KB2157114 April 2, 2012
- 2152472 How to troubleshoot SQL Server Errors that prevent a successful database startup or recovery Q2152472 KB2152472 April 2, 2012
- 2137539 FULL or BULK recovery models can provide better data protection and recovery Q2137539 KB2137539 April 2, 2012
- 2091098 Windows System Event Log Errors that indicate possible I/O problems can be associated with database inconsistency or performance problems for SQL Server Q2091098 KB2091098 April 2, 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
- 2078345 The database PAGE_VERIFY CHECKSUM option can help detect database consistency problems with the system I/O path Q2078345 KB2078345 April 2, 2012
- 2033523 Separate database and transaction log files on different drives for optimal performance and disaster recovery Q2033523 KB2033523 April 2, 2012
- 2033448 Winsock Layered Service Providers (LSP) may result in network or server stability problems for SQL Server Q2033448 KB2033448 April 2, 2012
- 2033344 Using unsupported .Net Framework assemblies with SQLCLR may cause problems after .Net upgrades Q2033344 KB2033344 April 2, 2012
- 2028712 Understanding Password Policy for SQL Server Logins. Q2028712 KB2028712 April 2, 2012
- 2028697 Recommendations and Guidelines on Configuring the Authentication Mode for SQL Server Q2028697 KB2028697 April 2, 2012
- 2028443 How to troubleshoot Event ID 12 with source Microsoft-Windows-HAL Q2028443 KB2028443 April 2, 2012
- 2028433 How to troubleshoot SQL Server error 17112 Q2028433 KB2028433 April 2, 2012
- 2028324 How to troubleshoot SQL Server error message 17890 Q2028324 KB2028324 April 2, 2012
- 2644592 The "awe enabled" SQL Server feature is deprecated Q2644592 KB2644592 March 31, 2012
- 2253635 FIX: MDX queries experience slow performance when a new SSAS role user connects to the SSAS database in SQL Server 2008 Analysis Services or in SQL Server 2008 R2 Analysis Services Q2253635 KB2253635 March 28, 2012
- 2588400 Reporting Services Charts are sized incorrectly or cropped Q2588400 KB2588400 March 26, 2012
- 2674882 "Error 1205" when you configure transactional replication in SQL Server 2005 or SQL Server 2008 Q2674882 KB2674882 March 23, 2012
- 2674878 "Error 1205" when you configure transactional replication in SQL Server 2005 or SQL Server 2008 Q2674878 KB2674878 March 23, 2012
- 2678763 When the Filestream feature is enabled in SQL Server 2008, you receive a Stop error, and the computer restarts unexpectedly Q2678763 KB2678763 March 21, 2012
- 2678759 When the Filestream feature is enabled in SQL Server 2008, you receive a Stop error, and the computer restarts unexpectedly Q2678759 KB2678759 March 21, 2012
- 2675518 FIX: Access violation when you run DML statements against a table that has partitioned indexes in SQL Server 2008 R2 Q2675518 KB2675518 March 12, 2012
- 2019779 You may receive incorrect values when using SCOPE_IDENTITY() and @@IDENTITY Q2019779 KB2019779 February 23, 2012
- 2675230 FIX: MDX query fails in SSAS 2008 R2 if the query contains a DAX expression that has many levels of nested binary operators Q2675230 KB2675230 February 22, 2012
- 2675226 FIX: MDX query fails in SSAS 2008 R2 if the query contains a DAX expression that has many levels of nested binary operators Q2675226 KB2675226 February 22, 2012
- 2644260 FIX: A main report is re-rendered when you click a link to view a drillthrough report in SSRS 2008 R2 Q2644260 KB2644260 February 22, 2012
- 2624915 FIX: Part of a report is not displayed when you use the Report Viewer Web Part on a SharePoint 2010 site to view a SSRS 2008 R2 report Q2624915 KB2624915 February 22, 2012
- 2676764 Recommended updates when you use data compression and table partitions Q2676764 KB2676764 February 16, 2012
- 245768 PRB: Case-Sensitive Unicode Collating Sequence and Windows NT Logins Q245768 KB245768 February 12, 2012
- 2531172 FIX: "Unable to obtain the current member" error when you run an MDX query in SQL Server 2008 Analysis Services or in SQL Server 2008 R2 Analysis Services Q2531172 KB2531172 January 17, 2012
- 2646528 Using rowguidcol in filter definition is not supported in merge replication Q2646528 KB2646528 January 10, 2012
- 2647118 Stream_Blob_Columns enabled by default when Filestream is enabled Q2647118 KB2647118 January 9, 2012
- 2633151 The SQL Server database transaction log file does not grow by the configured file growth value Q2633151 KB2633151 January 9, 2012
- 2633145 Cumulative update package 11 for SQL Server 2008 R2 Q2633145 KB2633145 January 9, 2012
- 2310152 Oracle publication triggers sends data for non-published columns when replicating with Microsoft SQL Server Q2310152 KB2310152 January 9, 2012
- 2643340 FIX: Action property does not work when you view an SSRS 2008 R2 report in Report Manager Q2643340 KB2643340 January 6, 2012