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.

• 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
• 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
• 953117 A maintenance plan that contains an Update Statistics task runs slowly after you install SQL Server 2005 Service Pack 2 Q953117 KB953117 May 27, 2008
• 842423 A call to the AuthzInitializeContextFromSid API function fails during the delivery of an e-mail subscription in SQL Server Reporting Services Q842423 KB842423 May 19, 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
• 950599 An SPN for the SQL Server Browser service is required when you establish a connection to a named instance of SQL Server 2005 Analysis Services or of SQL Server 2005 Q950599 KB950599 March 28, 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
• 905395 A change to the Readme.htm file for SQL Server 2005 Mobile Edition Q905395 KB905395 March 27, 2008
• 317375 A transaction log grows unexpectedly or becomes full on a computer that is running SQL Server Q317375 KB317375 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
• 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 February 4, 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
• 921896 A list of the bugs that are fixed in SQL Server 2005 Service Pack 2 Q921896 KB921896 December 3, 2007
• 247931 Authentication methods for connections to SQL Server in Active Server Pages Q247931 KB247931 December 3, 2007
• 936891 A memory leak may occur when the Merge Replication Agent retries a connection in SQL Server 2005 Q936891 KB936891 November 20, 2007
• 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 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
• 935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems Q935897 KB935897 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
• 918760 An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step Q918760 KB918760 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
• 913090 A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1 Q913090 KB913090 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
• 942981 An MDX query that contains an Aggregate function returns #Error for the cell values in SQL Server 2005 Analysis Services Q942981 KB942981 October 29, 2007
• 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 October 23, 2007
• 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 May 18, 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
• 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 April 16, 2007
• 920700 An introduction to SQL Server 2005 Compact Edition Q920700 KB920700 March 27, 2007
• 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 March 15, 2007
• 303229 A transaction log backup job that is created in Database Maintenance Planner fails to execute Q303229 KB303229 February 22, 2007
• 916940 A list of the new features and improvements that are included in SQL Server 2005 Service Pack 1 Q916940 KB916940 June 14, 2006
• 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
• 883732 A SQL Server cluster resource goes to a "failed" state when you try to bring the resource online in SQL Server 2005 or in SQL Server 2000 Q883732 KB883732 April 6, 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
• 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 March 3, 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
• 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 November 3, 2005