kbupdate.info ›
Daily Updated!
SQL Server 2008 articles, fixes and updates - Year 2012
Daily Updated!
chronological list: 2023 | ... 2019 | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010/12 11 10 9 8 ... 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 2012. The list is daily updated.
- 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
- 2777223 Workbook contains hidden rows and columns when you export reports from SQL Server Reporting Services to Excel Q2777223 KB2777223 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
- 2008286 Error message when you use Database Mail after you apply a SQL Server service pack or cumulative update: "System.IndexOutOfRangeException: timeout" Q2008286 KB2008286 October 23, 2012
- 2023536 Recommendations and Guidelines for 'max degree of parallelism' configuration option Q2023536 KB2023536 October 17, 2012
- 2716434 MS12-070: Description of the security update for SQL Server 2008 Service Pack 2 GDR: October 9, 2012 Q2716434 KB2716434 October 12, 2012
- 2754849 MS12-070: Vulnerability in SQL Server could allow elevation of privilege: October 9, 2012 Q2754849 KB2754849 October 9, 2012
- 2716436 MS12-070: Description of the security update for SQL Server 2008 Service Pack 3 GDR: October 9, 2012 Q2716436 KB2716436 October 9, 2012
- 2716435 MS12-070: Description of the security update for SQL Server 2008 Service Pack 3 QFE: October 9, 2012 Q2716435 KB2716435 October 9, 2012
- 2716433 MS12-070: Description of the security update for SQL Server 2008 Service Pack 2 QFE: October 9, 2012 Q2716433 KB2716433 October 9, 2012
- 2755960 SQL query performance might decrease when the SQL Server Database instance has high index fragmentation Q2755960 KB2755960 September 27, 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
- 917409 How to configure SQL Server 2008 Analysis Services and SQL Server 2005 Analysis Services to use Kerberos authentication Q917409 KB917409 August 16, 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
- 2715951 Cumulative update package 11 for SQL Server 2008 Service Pack 2 Q2715951 KB2715951 July 16, 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
- 2000380 SQL Server 2005 and SQL Server 2008 reports 701 errors with large batch sizes Q2000380 KB2000380 June 26, 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
- 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
- 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
- 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
- 2194498 SQL Server Best Practices Analyzer - Subscription Does not Match Publication Because Skipped Transactions Q2194498 KB2194498 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
- 2001727 SQL Server 2008 setup fails to complete when instance name contains Arabic characters Q2001727 KB2001727 April 13, 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
- 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
- 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
- 2157327 Attribute Type Defined That Doesn't Match Dimension Type Q2157327 KB2157327 April 2, 2012
- 2157299 Time or Account Attribute Types Found for non-Account/Time Dimension Type Q2157299 KB2157299 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
- 2141654 Avoid having 10 or more dimensions with a single attribute. Consider unifying them. Q2141654 KB2141654 April 2, 2012
- 2137539 FULL or BULK recovery models can provide better data protection and recovery Q2137539 KB2137539 April 2, 2012
- 2135112 Use MOLAP storage mode for dimensions when those dimensions are related to measure groups that contain semi-additive measures Q2135112 KB2135112 April 2, 2012
- 2135031 Optimal configuration settings for high concurrency in SSAS Q2135031 KB2135031 April 2, 2012
- 2134855 Process thread pool MinThreads should be at least the number of logical CPUs on machine with 8 or more CPUs Q2134855 KB2134855 April 2, 2012
- 2134497 Process thread Pool MaxThreads exceeds recommended value Q2134497 KB2134497 April 2, 2012
- 2134431 Avoid having more than three parent-child dimensions containing unary operator or custom rollup in a database Q2134431 KB2134431 April 2, 2012
- 2132742 Avoid ROLAP storage mode or enabling proactive caching with immediate OnlineMode for dimensions containing unary operator or custom rollups Q2132742 KB2132742 April 2, 2012
- 2131918 Avoid having large parent-child dimensions that have 500000 or more members for the key attribute Q2131918 KB2131918 April 2, 2012
- 2128005 Flight Recorder eanbled for SQL Server Analysis Services Q2128005 KB2128005 April 2, 2012
- 2127862 Non-Standard Attribute Relationship Names Q2127862 KB2127862 April 2, 2012
- 2127570 Avoid diamond shape relationships Q2127570 KB2127570 April 2, 2012
- 2127437 Avoid redundant attribute relationships Q2127437 KB2127437 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
- 2028143 Disable attribute hierarchy or attribute optimization for large non-key attributes Q2028143 KB2028143 April 2, 2012
- 2028138 Non-numeric key column used for high cardinality attribute Q2028138 KB2028138 April 2, 2012
- 2027769 No default member defined for non-aggregatable attribute Q2027769 KB2027769 April 2, 2012
- 2027761 Analysis Services should not ignore duplicate keys Q2027761 KB2027761 April 2, 2012
- 2027754 No slice set on partition Q2027754 KB2027754 April 2, 2012
- 2027628 UnknownMember is set to hidden for one or more dimensions Q2027628 KB2027628 April 2, 2012
- 2027609 Measure groups with no dimensional overlap detected Q2027609 KB2027609 April 2, 2012
- 2027603 Default measure of a perspective not included in the perspective Q2027603 KB2027603 April 2, 2012
- 2027545 Measure group defined with no partition Q2027545 KB2027545 April 2, 2012
- 2027541 Proactive Caching enabled objects should have a processing query Q2027541 KB2027541 April 2, 2012
- 2027532 No Time dimension defined Q2027532 KB2027532 April 2, 2012
- 2027474 Excessive memory pre-allocated to Analysis Services Q2027474 KB2027474 April 2, 2012
- 2027472 Non-standard value detected for Analysis Service memory configuration Q2027472 KB2027472 April 2, 2012
- 2027468 Define 'Rigid' attribute relationships when possible Q2027468 KB2027468 April 2, 2012
- 2027460 Possible incorrect hierarchy levels defined for dimension Q2027460 KB2027460 April 2, 2012
- 2027459 Attribute property types not compatible Q2027459 KB2027459 April 2, 2012
- 2027418 No Time or Account attributes found for dimension of type Time or Account Q2027418 KB2027418 April 2, 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
- 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
- 2673383 Cumulative update package 4 for SQL Server 2008 Service Pack 3 Q2673383 KB2673383 March 20, 2012
- 2673993 FIX: "The index data is damaged" error message when you run an MDX query against a dimension or partition in SSAS 2008 Q2673993 KB2673993 March 19, 2012
- 2673378 Cumulative update package 9 for SQL Server 2008 Service Pack 2 Q2673378 KB2673378 March 19, 2012
- 2673247 PRB: MSG 5009 when you try to remove a logical file in SQL Server 2008 Q2673247 KB2673247 March 12, 2012
- 2019779 You may receive incorrect values when using SCOPE_IDENTITY() and @@IDENTITY Q2019779 KB2019779 February 23, 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
- 2660492 FIX: "Internal error" message when you run an MDX query in SQL Server 2008 Analysis Services Q2660492 KB2660492 January 31, 2012
- 2635540 FIX: "Incorrect syntax" error message when you use a catalog database whose name contains a special character in SSRS 2008 Q2635540 KB2635540 January 17, 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
- 2648098 Cumulative update package 3 for SQL Server 2008 Service Pack 3 Q2648098 KB2648098 January 16, 2012
- 2625989 "Cannot download the information you requested" error in SSRS 2008 when you click a drillthrough report link Q2625989 KB2625989 January 16, 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
- 2310152 Oracle publication triggers sends data for non-published columns when replicating with Microsoft SQL Server Q2310152 KB2310152 January 9, 2012