SQL Server 2005 articles, fixes and updates - Year 2006

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2005 that have been released in Year 2006. The list is daily updated.

• 910228 SQL Server 2005 Readme and installation requirements Q910228 KB910228 December 7, 2006
• 813731 How to retrieve data from a SQL Server CE 2.0 database or from a SQL Server 2005 Compact Edition database and save the data in an XML document Q813731 KB813731 December 7, 2006
• 330741 BUG: A transfer of data from a SQL Server CE or SQL Server 2005 Compact Edition database to a remote SQL Server database fails when you use the Push method in SQL Server CE Remote Data Access Q330741 KB330741 December 7, 2006
• 924151 Error message when you run a distributed transaction on a SQL Server 2005-based or SQL Server 2000-based failover cluster: "Resource Manager creation failed: result code = 0x8004d102" Q924151 KB924151 December 1, 2006
• 910544 BUG: You cannot repair or uninstall SQL Server 2005 Reporting Services after you uninstall and then reinstall Internet Information Services 6.0 Q910544 KB910544 November 22, 2006
• 915692 Error message when you try to install SQL Server 2005 Service Pack 1: "The following files are currently locked" Q915692 KB915692 November 20, 2006
• 928318 Error message when you run an MDX query in SQL Server 2005 Analysis Services: "The MDX function CURRENTMEMBER failed because the coordinate for the 'AttributeName' attribute contains a set" Q928318 KB928318 November 17, 2006
• 926623 Error message when you install SQL Server 2005 Service Pack 1 after you upgrade a Windows operating system or after you install a Windows service pack: "Error 29513 SQL Server Setup Failed to compile the Managed Object Format (MOF) file" Q926623 KB926623 October 31, 2006
• 916766 Error message when you try to install a SQL Server 2005 service pack: "SQL Server Setup failed to modify security permissions on file Drive:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\Data\ for user SYSTEM" Q916766 KB916766 October 17, 2006
• 920992 BUG: Error message when you try to perform a grouping operation on an Excel pivot table that uses a SQL Server 2005 Analysis Services cube as a data source: "The permission required for this operation has not been granted" Q920992 KB920992 September 18, 2006
• 253817 How to back up the last transaction log when the master and the database files are damaged in SQL Server Q253817 KB253817 September 11, 2006
• 922267 BUG: Error message when you process a mining structure in SQL Server 2005 Analysis Services: "Internal error: An unexpected error occurred (file 'dmcorrcountutils.cpp', line 2045, function 'DMCC_WorkerJobCaseProcessor::CacheCase')" Q922267 KB922267 August 28, 2006
• 818548 Error message when you run SQL Server Setup on a failover cluster: "Setup failed to perform required operations on the cluster nodes" Q818548 KB818548 August 7, 2006
• 918481 How to install Microsoft Operations Manager (MOM) 2005 Service Pack 1 databases and MOM 2005 Reporting on a computer that has Microsoft SQL Server 2005 installed Q918481 KB918481 August 4, 2006
• 922669 Error message when you install SQL Server 2005 on a computer that is running the original release version of Windows XP: "This application has failed to start because the application configuration is incorrect" Q922669 KB922669 July 31, 2006
• 921110 Error message when you install SQL Server 2005 Service Pack 1 or SQL Server 2005 Express Edition: "Another installation is already in progress. Complete that installation before proceeding with this install" Q921110 KB921110 July 12, 2006
• 908038 You may receive an error message when you try to add a user control to a Windows Forms-based application if the user control contains a data-binding object that uses an attached local database file in Visual Studio 2005 Q908038 KB908038 June 12, 2006
• 233332 How to run the SQLdiag utility on a clustered instance of SQL Server or on virtual SQL Server Q233332 KB233332 June 9, 2006
• 915698 Error message when you change the SQL Server service account for a clustered instance of SQL Server 2005: "The system cannot find the file specified." Q915698 KB915698 June 6, 2006
• 919236 Error message when you start SQL Server 2005 Management Studio: "Input string was not in a correct format" Q919236 KB919236 June 5, 2006
• 910375 FIX: No table headers appear in the Excel report when you use SQL Server 2005 Reporting Services to export information to Excel Q910375 KB910375 June 1, 2006
• 918478 When you connect to the SQL Server 2005 database engine, you may experience longer connection times Q918478 KB918478 May 18, 2006
• 918480 The part of a script that is defined on an indexed view is not generated when you script an SMO object that is related to the indexed view in SQL Server 2005 Q918480 KB918480 May 17, 2006
• 917826 Error message when you reinstall an instance of SQL Server 2005 Reporting Services by using a domain account: "Fatal error during installation" Q917826 KB917826 April 28, 2006
• 917421 Some rows are not displayed when you create a model-based report in SQL Server 2005 Reporting Services Q917421 KB917421 April 27, 2006
• 917635 BUG: Error message when you try to use Visual Studio 2005 to connect to a remote instance of SQL Server after you uninstall SQL Server Management Studio Express (SSMSE): "Class not Registered" Q917635 KB917635 April 26, 2006
• 914640 Error message when you try to convert a string to the XML data type in SQL Server 2005: "Cannot bind to the reserved namespace" Q914640 KB914640 April 25, 2006
• 915854 You receive an error message when you try to uninstall the second named instance of SQL Server 2005 Q915854 KB915854 April 18, 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
• 915693 The GUIDs for the new schema rowsets in SQL Server 2005 Analysis Services are not included in the Msmd.h file Q915693 KB915693 April 18, 2006
• 914780 Error message when you try to use a merge publication that you created in SQL Server 2005: "Precomputed partitions cannot be used" Q914780 KB914780 April 18, 2006
• 841251 How to enable SQL Server connectivity on Windows XP Service Pack 2 Q841251 KB841251 April 18, 2006
• 915856 How to set a default member of a dimension to a calculated member in SQL Server 2005 Analysis Services Q915856 KB915856 April 14, 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
• 811891 SQL Server only uses 2 GB of memory even though the AWE option is enabled Q811891 KB811891 April 12, 2006
• 916785 The INSERT operation is very slow when you try to insert many rows into a table that contains a full-text index Q916785 KB916785 April 11, 2006
• 842425 How to move a Reporting Services database from a computer that is running Reporting Services to another computer Q842425 KB842425 April 7, 2006
• 311846 Description of names and IP addresses that an MSDTC client in a cluster environment must have Q311846 KB311846 April 7, 2006
• 290624 How to configure MSDTC in a Windows 2000 cluster environment Q290624 KB290624 April 7, 2006
• 915050 Error message when you use the sys.dm_exec_query_plan dynamic management function to return a Showplan in XML format for a Transact-SQL batch: "A system assertion check has failed" Q915050 KB915050 April 6, 2006
• 915047 When you try to run a query in a query editor in SQL Server Management Studio, a query in a different query editor runs instead Q915047 KB915047 April 6, 2006
• 914638 You receive a NULL value when you use XQuery to retrieve the value of an XML element in SQL Server 2005 Q914638 KB914638 April 6, 2006
• 319578 Error message when you change the IP address on a SQL Server failover cluster node: "Bind failed" Q319578 KB319578 April 6, 2006
• 912136 You may experience problems after you run the Business Intelligence Wizard to add time calculations in SQL Server 2005 Analysis Services Q912136 KB912136 April 5, 2006
• 915180 You can no longer enlist the target server into the master server after you change the service account for the SQL Server Agent service Q915180 KB915180 April 4, 2006
• 916784 How to perform full-text search related tasks in SQL Server 2005 Express Edition with Advanced Services Q916784 KB916784 April 3, 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
• 319716 How to populate a SQL Server 2005 database by using information from Active Directory Q319716 KB319716 March 21, 2006
• 915074 BUG: Error message when you try to use the DELETE statement to delete rows from a remote table on a linked server: "Statement(s) could not be prepared" Q915074 KB915074 March 18, 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
• 811876 Network adapters disappear from network adapters list and cluster server stops responding Q811876 KB811876 March 14, 2006
• 906564 How to use SQL Server Business Intelligence Development Studio or the dtutil utility to regenerate the package ID of an SSIS package that was duplicated Q906564 KB906564 March 11, 2006
• 906563 How to interpret data that is logged by using a SQL Server 2005 Integration Services log provider Q906563 KB906563 March 11, 2006
• 905006 Description of the type mapping of the new SQL Server 2005 data types in the OLE DB Provider for SQL Server (SQLOLEDB) and SQL Native Client Q905006 KB905006 March 11, 2006
• 904799 The "Data Source" field is a text box, the Refresh button does not appear, and you cannot attach a database file as a database name when you try to create a Microsoft Data Link file by using the SQL Native Client provider in SQL Server 2005 Q904799 KB904799 March 11, 2006
• 904798 SSIS packages that are currently running may unexpectedly stop responding when you restart the SSIS service in SQL Server 2005 Q904798 KB904798 March 11, 2006
• 904796 You cannot run or schedule various packages that require SQL Server 2000 Meta Data Services files after you upgrade to SQL Server 2005 Q904796 KB904796 March 11, 2006
• 914261 Error message when you run the ALTER SERVICE MASTER KEY REGENERATE statement in SQL Server 2005: "The current master key cannot be decrypted" Q914261 KB914261 March 8, 2006
• 910890 SSIS reports that a query was successful when a SQLOLEDB provider ends an SSIS query because of a server error Q910890 KB910890 March 3, 2006
• 913815 Error message when you install a SQL Server 2005 failover cluster on a node: "The drive specified cannot be used for program location" Q913815 KB913815 March 1, 2006
• 914159 Error message when you try to browse a report in SQL Server 2005 Reporting Services: "The input XML is not well-formed" Q914159 KB914159 February 27, 2006
• 912417 The module information is represented incorrectly when you profile managed code that is running in SQL Server 2005 by using performance tools in Visual Studio Team Edition for Software Developers Q912417 KB912417 February 15, 2006
• 913392 Error message when you open SQL Server 2005 Books Online: "Microsoft Document Explorer cannot be shown because the specified help collection 'ms-help://MS.SQLCC.v9' is invalid" Q913392 KB913392 February 14, 2006
• 913046 SQL Server 2005 Reporting Services does not save dump files to the location that you specify in the Dr. Watson for Windows tool Q913046 KB913046 February 14, 2006
• 912396 Error message when you try to run an MDX query on a ROLAP-based dimension in SQL Server 2005 Analysis Services: "Server: The operation has been cancelled" Q912396 KB912396 February 14, 2006
• 912390 BUG: SQL Server 2005 Analysis Services still generates aggregations on the (All) member of a dimension when you set the value of the AllMemberAggregationUsage property to None Q912390 KB912390 February 7, 2006
• 912421 BUG: Error message when you run, import, or migrate a SQL Server 2000 DTS package that contains an instance of the Analysis Services Processing task in SQL Server 2005: "Invalid class string" Q912421 KB912421 February 1, 2006
• 911307 The operation is delayed for several minutes when you run a Transact-SQL statement or a module that has an EXECUTE AS clause in SQL Server 2005 Q911307 KB911307 February 1, 2006
• 907716 How to obtain SQL Server Management Studio Express (SSMSE) community technology preview (CTP) Q907716 KB907716 January 31, 2006
• 909392 OLAP assemblies and binary files that Microsoft supports for programmability in SQL Server Analysis Services 2005 Q909392 KB909392 January 25, 2006
• 911839 How to change the SQL Server 2005 service accounts by using the Windows Management Instrumentation (WMI) Provider for Configuration Management Q911839 KB911839 January 23, 2006
• 908503 Description of the "Error 1619 installing sqlncli.dll" error message that you may receive when you install SQL Server 2005 Q908503 KB908503 January 16, 2006
• 912389 BUG: The query does not use the indexed view in SQL Server 2005 Enterprise Edition Q912389 KB912389 January 11, 2006
• 839980 How to use a script to programmatically open ports for SQL Server to use on systems that are running Windows XP Service Pack 2 Q839980 KB839980 January 11, 2006
• 911844 Information in a TextBox control appears as "#Error" after you upgrade from SQL Server 2000 Reporting Services to SQL Server 2005 Reporting Services Q911844 KB911844 January 3, 2006
• 319264 Crystal Report in a Web application fails to log on to SQL Server Q319264 KB319264 January 2, 2006