SQL Server 2008 articles, fixes and updates - letter A

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2008 starts with letter A that have been released. The list is daily updated.

• 3034373 An on-demand hotfix update package is available for SQL Server 2008 SP4 Q3034373 KB3034373 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
• 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
• 2666213 A TDE-enabled database may not recover in SQL Server 2008 or in SQL Server 2008 R2 Q2666213 KB2666213 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
• 935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems Q935897 KB935897 January 12, 2021
• 950599 An SPN for the SQL Server Browser service is required when you establish a connection to a named instance of SQL Server Analysis Services Q950599 KB950599 December 17, 2020
• 956139 Actions that are required before you install SQL Server 2008 on a computer that has Visual Studio 2008 or the prerelease version of SQL Server 2008 installed Q956139 KB956139 May 31, 2020
• 2508239 An AFTER INSERT trigger may not work correctly after you apply the fix documented in 975950 Q2508239 KB2508239 November 20, 2019
• 2470176 Applications may fail after upgrading your database from SQL Server 2000 to a later version Q2470176 KB2470176 November 20, 2019
• 317375 A transaction log grows unexpectedly or becomes full in SQL Server Q317375 KB317375 November 15, 2019
• 4504103 ASR Agent or other non-component VSS backup fails for a server hosting SQL Server 2008 R2 Q4504103 KB4504103 June 17, 2019
• 4345020 Announcing new options for SQL Server and Windows Server 2008 End of Support (July 12, 2018) Q4345020 KB4345020 September 10, 2018
• 842423 A call to the AuthzInitializeContextFromSid API function fails during the delivery of an e-mail subscription in SQL Server Reporting Services Q842423 KB842423 April 20, 2018
• 883732 A SQL Server cluster resource goes to a "failed" state when you try to bring the resource online in SQL Server Q883732 KB883732 April 17, 2018
• 955798 Availability of AdventureWorks sample databases for SQL Server 2008 Q955798 KB955798 April 13, 2018
• 156932 Asynchronous Disk I/O Appears as Synchronous on Windows Q156932 KB156932 June 25, 2015
• 3051225 A filtered index that you create together with the IS NULL predicate is not used in SQL Server Q3051225 KB3051225 April 28, 2015
• 955621 A SQL Server Integration Services (SSIS) package in SQL Server 2008 that contains a Script task or a Script component does not run on a Windows Server 2003 Itanium-based computer Q955621 KB955621 January 16, 2015
• 2561774 Access to the installation media for SQL Server 2008 R2 may be required when you install SQL Server 2008 side by side with a SQL Server 2008 R2 instance Q2561774 KB2561774 June 21, 2014
• 2913774 An index build takes a long time when a SQL Server database backup is running Q2913774 KB2913774 December 9, 2013
• 2014053 A memory leak occurs in the FDHOST.exe process in SQL Server 2008 or in SQL Server 2008 R2 Q2014053 KB2014053 October 30, 2013
• 2635199 A format-binding element is ignored in a multidimensional database in SQL Server Q2635199 KB2635199 May 26, 2012
• 2598605 A custom SQL Server business logic handler replaces an empty string with an end-of-string character Q2598605 KB2598605 May 22, 2012
• 2157327 Attribute Type Defined That Doesn't Match Dimension Type Q2157327 KB2157327 April 2, 2012
• 2141654 Avoid having 10 or more dimensions with a single attribute. Consider unifying them. Q2141654 KB2141654 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
• 2127570 Avoid diamond shape relationships Q2127570 KB2127570 April 2, 2012
• 2127437 Avoid redundant attribute relationships Q2127437 KB2127437 April 2, 2012
• 2027761 Analysis Services should not ignore duplicate keys Q2027761 KB2027761 April 2, 2012
• 2027459 Attribute property types not compatible Q2027459 KB2027459 April 2, 2012
• 978947 A non-yielding issue may cause a database mirroring failover in SQL Server 2005 and in SQL Server 2008 Q978947 KB978947 October 7, 2011
• 977305 An application stops responding when it connects to SQL Server 2008 or to SQL Server 2005 by using Java Database Connectivity Driver 2.0 Q977305 KB977305 October 7, 2011
• 982895 Analysis SQL Transactional Replication High Latency Q982895 KB982895 October 5, 2011
• 2019126 A Data Collector collection set may not be uploaded if a cache file is corrupted Q2019126 KB2019126 August 19, 2011
• 982808 A drillthrough report may not work incorrectly correctly if the "Prompt for credentials" option is used in the data sources in SQL Server 2008 Reporting Service or in SQL Server 2008 R2 Reporting Services Q982808 KB982808 December 20, 2010
• 2983446 A SSRS 2008 report shows duplicate first row for each group of a subreport when you export the report to CSV format Q2983446 KB2983446 November 15, 2010
• 983446 A SSRS 2008 report shows duplicate first row for each group of a subreport when you export the report to CSV format Q983446 KB983446 November 15, 2010
• 2400023 Agent message code 2812. Could not find stored procedure ‘sp_MSget_min_seqno’. Q2400023 KB2400023 September 15, 2010
• 2216472 A SQL Server 2008 or SQL Server 2005 Analysis Services ROLAP query returns incorrect results Q2216472 KB2216472 July 19, 2010
• 2157941 Analysis Services server is running a build with a known regression Q2157941 KB2157941 June 18, 2010
• 977813 A version of Microsoft SQL Server 2008 Express that supports the .NET Framework 4 Beta 2 is available at Microsoft Download Center Q977813 KB977813 January 19, 2010
• 970307 An index corruption occurs when you crawl the content sources on a computer that is running Windows SharePoint Services 3.0 or Office SharePoint Server 2007, and a power outage occurs on the computer Q970307 KB970307 August 17, 2009
• 956008 After you install a SQL Server 2008 failover cluster in a disk that contains a mounted volume, no dependencies are created between the mounted volume and the disk Q956008 KB956008 August 14, 2009
• 972833 An additional scroll bar appears when you use Outlook 2003 to open a SQL Server 2008 Reporting Services report that is sent in MHTML format in an e-mail message Q972833 KB972833 July 24, 2009
• 955721 A replication job does not run successfully in SQL Server 2008, and you may see a message that resembles the following when you view the replication agent status: "The replication agent has not logged a progress message in 10 minutes." Q955721 KB955721 March 27, 2009
• 956022 A query whose WHERE clause references a spatial column may return an incorrect or empty result in Microsoft SQL Server 2008 Q956022 KB956022 March 19, 2009
• 955667 A repair operation fails when you repair a stand-alone instance of SQL Server 2008 that is installed on a node of a server cluster Q955667 KB955667 March 19, 2009
• 955643 A delimited flat file is parsed incorrectly when you use the Flat File source or a Flat File connection manager in SQL Server 2008 Q955643 KB955643 March 19, 2009
• 955620 A SQL Server 2005 Integration Services package that contains a Script task or a Script component does not run in SQL Server 2008 Q955620 KB955620 March 19, 2009
• 955508 An error message contains invalid DatasetName data when you generate a report in SQL Server 2008 Reporting Services Q955508 KB955508 March 19, 2009
• 955831 An access violation error message is logged in the SQL Server error log after you upgrade to SQL Server 2008: "Access Violation occurred reading address 00000000" Q955831 KB955831 January 7, 2009
• 956154 Activity Monitor or Performance Monitor may stop responding (hang) after you upgrade SQL Server Reporting Services 2008 CTP6 to SQL Server Reporting Services 2008 RTM Q956154 KB956154 August 11, 2008