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

• 2527494 An update for SQL Server Compact 3.5 SP2 is available to add support for replication operations that use SQL Server "Denali" Q2527494 KB2527494 January 26, 2021
• 968381 All records in the query log table are truncated when you synchronize a database in SQL Server Analysis Services Q968381 KB968381 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
• 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
• 920700 An introduction to SQL Server 2005 Compact Edition Q920700 KB920700 April 30, 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
• 921896 A list of the bugs that are fixed in SQL Server 2005 Service Pack 2 Q921896 KB921896 November 20, 2019
• 317375 A transaction log grows unexpectedly or becomes full in SQL Server Q317375 KB317375 November 15, 2019
• 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
• 303229 A transaction log backup job that is created in Database Maintenance Planner fails to execute Q303229 KB303229 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
• 903002 A "Failed to reserve contiguous memory" error message may be logged in the SQL Server error log when users connect to an instance of SQL Server by using a network packet size that is larger than 8,060 bytes Q903002 KB903002 April 13, 2018
• 914847 A user may be able to access objects in other schemas when you grant the ALTER permission on a schema to the user in SQL Server 2005 Q914847 KB914847 December 9, 2015
• 907886 A System.InvalidOperationException exception may occur when you try to use a Visual Studio .NET 2003 client application against a SQL Server 2005 native Web service Q907886 KB907886 December 9, 2015
• 905395 A change to the Readme.htm file for SQL Server 2005 Mobile Edition Q905395 KB905395 January 16, 2015
• 934096 All the columns are displayed if you do not define any dimensions or any return columns when you create a drillthrough action in SQL Server 2005 Analysis Services Q934096 KB934096 January 14, 2015
• 247931 Authentication methods for connections to SQL Server in Active Server Pages Q247931 KB247931 June 22, 2014
• 2913774 An index build takes a long time when a SQL Server database backup is running Q2913774 KB2913774 December 9, 2013
• 953117 A maintenance plan that contains an Update Statistics task runs slowly after you install SQL Server 2005 Service Pack 2 Q953117 KB953117 November 2, 2013
• 942839 An MDX query returns additional cell data when you use the IsEmpty function on the query axis in Analysis Services with SQL Server 2005 Service Pack 2 Q942839 KB942839 November 2, 2013
• 916940 A list of the new features and improvements that are included in SQL Server 2005 Service Pack 1 Q916940 KB916940 October 24, 2012
• 2635199 A format-binding element is ignored in a multidimensional database in SQL Server Q2635199 KB2635199 May 26, 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
• 982895 Analysis SQL Transactional Replication High Latency Q982895 KB982895 October 5, 2011
• 942981 An MDX query that contains an Aggregate function returns #Error for the cell values in SQL Server 2005 Analysis Services Q942981 KB942981 September 17, 2011
• 924939 An update is available for SQL Server 2005 Analysis Services that adds partition information to the existing schema that is returned by the DISCOVER_PARTITION_INFO rowset Q924939 KB924939 September 17, 2011
• 2400023 Agent message code 2812. Could not find stored procedure ‘sp_MSget_min_seqno’. Q2400023 KB2400023 September 15, 2010
• 948208 An additional resource group that contains no resources is created after you install a second failover clustered instance of SQL Server 2005 on a Windows Server 2008-based server Q948208 KB948208 September 11, 2010
• 2284190 Applications cannot connect to a mirror partner server when using port number in the failoverPartner attribute of the connection string Q2284190 KB2284190 August 18, 2010
• 2216472 A SQL Server 2008 or SQL Server 2005 Analysis Services ROLAP query returns incorrect results Q2216472 KB2216472 July 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
• 929728 An instance of SQL Server performs slowly when you use SQL Profiler to perform a client-side trace of the events in the instance Q929728 KB929728 September 30, 2008
• 936491 After you install a 64-bit version of SQL Server 2005 on a 64-bit version of Windows, the 32-bit entries for SQL Native Client Configuration and for SQL Server 2005 Network Configuration appear in SQL Server Configuration Manager Q936491 KB936491 June 13, 2008
• 913090 A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1 Q913090 KB913090 June 13, 2008
• 953122 A tape device is not detected by SQL Server Management Studio in SQL Server 2005 or by SQL Server Enterprise Manager in SQL Server 2000 Q953122 KB953122 June 10, 2008
• 953119 A CROSS JOIN clause is automatically inserted into an UPDATE statement that uses an INNER JOIN clause when you execute the statement in the SQL pane of SQL Server Management Studio Q953119 KB953119 May 27, 2008
• 952217 A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000 Q952217 KB952217 May 8, 2008
• 914827 An .sdf database file in SQL Server 2005 Compact Edition or in SQL Server 2005 Mobile Edition is larger than the same .sdf database file in SQL Server CE 2.0 when you use the ntext data type or the image data type Q914827 KB914827 March 27, 2008
• 296076 A Windows CE device power failure that occurs during a transaction commit may cause a SQL Server CE database to be marked suspect Q296076 KB296076 March 26, 2008
• 929151 A service pack does not install on a x64-based passive node cluster computer that is running SQL Server 2005 Q929151 KB929151 February 4, 2008
• 938085 A clean-up task does not delete database maintenance plan reports after you install SQL Server 2005 Service Pack 2 Q938085 KB938085 January 21, 2008
• 936891 A memory leak may occur when the Merge Replication Agent retries a connection in SQL Server 2005 Q936891 KB936891 November 20, 2007
• 935997 A user who is not a member of a required role can still connect to a SQL Server 2005 database after you set the user access option for the database to RESTRICTED_USER Q935997 KB935997 November 20, 2007
• 933838 Additional updates and additional inserts may be performed during synchronization when the merge publication contains join filters in SQL Server 2005 Q933838 KB933838 November 20, 2007
• 933248 All conditional and branching statements are ignored when you try to execute a batch of Transact-SQL statements that have the FTMONLY option set to ON in SQL Server 2005 Q933248 KB933248 November 20, 2007
• 930048 A query notification dependency between an application and a SQL Server 2005 database does not detect the changes in the database after a database mirroring failover Q930048 KB930048 November 20, 2007
• 915385 A snapshot-based database backup restore process may fail, and you may receive an error message in SQL Server 2005 Q915385 KB915385 November 20, 2007
• 905693 Additions to the Readme file for the SQL Server 2005 Upgrade Advisor tool Q905693 KB905693 November 20, 2007
• 943285 After you install Cumulative Update Package 4 for SQL Server 2005 SP2, time stamp information that is related to the RSPrintClient ActiveX control is logged in the report server log file Q943285 KB943285 November 1, 2007
• 941742 A cube is not modified when you process the cube by using the ProcessDefault option in SQL Server 2005 Analysis Services Q941742 KB941742 October 30, 2007
• 818202 A "Database log truncated" error is logged in the Event Log when you try to back up the transaction log Q818202 KB818202 May 16, 2007
• 935996 An MDX query takes longer than you expect to finish in SQL Server 2005 Analysis Services Q935996 KB935996 April 19, 2007
• 915853 After you convert a report from SQL Server 2000 Reporting Services to SQL Server 2005 Reporting Services, you receive an error message, and you cannot preview the report in Visual Studio 2005 Q915853 KB915853 April 18, 2006
• 915855 All member relationships are returned when you set the AttributeRelationship Visible property of an attribute to true or to false in SQL Server 2005 Analysis Services Q915855 KB915855 April 13, 2006
• 915851 All the measures of the cube are displayed when you browse a cube by using a perspective that does not have a specified measure Q915851 KB915851 March 25, 2006
• 914805 An expression that you defined in a data flow task does not appear in the Property Expressions Editor dialog box in SQL Server 2005 Q914805 KB914805 March 17, 2006
• 268481 A SQL Server backup is invalid when the backup is performed on a computer that is configured to use a DPT RAID controller card Q268481 KB268481 December 28, 2005