A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1 (913090)



The information in this article applies to:

  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Workgroup
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Notification Services
  • Microsoft SQL Server 2005 Reporting Services

INTRODUCTION

This article contains information about the bugs that have been fixed in Microsoft SQL Server 2005 Service Pack 1.

Note
  • Other fixes may be included in the service pack that are not documented.
  • This list will be updated as more articles are released.
For more information about how to obtain SQL Server 2005 service packs, click the following article number to view the article in the Microsoft Knowledge Base:

913089 How to obtain the latest service pack for SQL Server 2005

MORE INFORMATION

For more information about the bugs that have been fixed in SQL Server 2005 Service Pack 1, click the following article numbers to view the articles in the Microsoft Knowledge Base:
910375FIX: No table headers appear in the Excel report when you use SQL Server 2005 Reporting Services to export information to Excel
910376FIX: You may unexpectedly receive a zero or null return value when you run an MDX query on relational OLAP partitions in SQL Server 2005 Analysis Services
910414FIX: You may receive an error message when you try to load data by using CLR functions in a Transact-SQL job in SQL Server 2005
910416FIX: Error message when you run certain queries or certain stored procedures in SQL Server 2005: "A severe error occurred on the current command"
910418FIX: You may receive an error message when you try to connect to SQL Server 2005 Analysis Services by using an ADO connection string that uses the CustomData property
911912FIX: You experience low CPU spikes at set intervals even when there is no user activity in SQL Server 2005
911937FIX: The schema that indicates the Identity column in the source database is not transferred to the destination database when you try to transfer objects from a source database to a destination database by using SQL Management Objects in SQL Server 2005
912001FIX: Error message when you design aggregations in the Aggregation Design Wizard in SQL Server 2005 Analysis Services: "Internal error an unexpected exception occurred"
912016FIX: Error message when you process a dimension by using the Process Update processing option or the Process Default processing option in SQL Server 2005 Analysis Services: "Operation has been cancelled"
912017FIX: Error message when you connect to an instance of SQL Server 2005 Analysis Services: "A connection cannot be made. Ensure that the server is running."
912021FIX: You may receive an error message when you try to use backup software to back up a database in SQL Server 2005 for Itanium-based Systems
912136You may experience problems after you run the Business Intelligence Wizard to add time calculations in SQL Server 2005 Analysis Services
912322FIX: An application query that reads lots of data may be slow, and the SQL Server service may take a long time to start in SQL Server 2005
912419FIX: The attribute hierarchy for an attribute still appears when you browse a cube even if you set the value of the AttributeHierarchyVisible property for the attribute to False in SQL Server 2005 Analysis Services
912422FIX: The synchronous database mirroring session status may remain disconnected when you set up synchronous database mirroring but do not configure a witness database and you run a DBCC STACKDUMP command in SQL Server 2005
912423FIX: Memory leaks occur when you use Fuzzy Lookup and Fuzzy Grouping to transform a SQL Server 2005 Integration Services package
912429FIX: Error message when you run an MDX statement to query data from a SQL Server 2005 Analysis Services database: "Internal error An unexpected exception occurred"
912439FIX: Error message when you try to run several queries on large data sets at the same time in SQL Server 2005: "701 There is insufficient system memory to run this query"
912446FIX: You receive an incorrect result when you execute a DISCOVER request or call the AdomdConnection.GetSchemaDataSet method against a SQL Server 2005 Analysis Services server
912450FIX: You may receive a null value for a calculated member when you run an MDX query in SQL Server 2005 Analysis Services
912459FIX: Error message when you query data from a SQL Server 2005 Analysis Services database by using the HTTP protocol: "Xml Parsing failed"
912471FIX: The replication on the server does not work any longer when you manually fail over databases in SQL Server 2005
912472FIX: An incorrect result may appear in the subscribing database when you set database mirroring for a database and database failover occurs in SQL Server 2005
912702FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services: "Dimension attribute was not found"
912705FIX: Error message when you try to drill through a report in SQL Server 2005 Reporting Services: "An internal error occurred on the report server. See the error log for more details"
912885FIX: You may receive an access violation error message when you run a parallel execution plan in SQL Server 2005
913363FIX: You receive an error message when you use SQL Server 2005 Reporting Services to run a report that has two or more parameters
913371FIX: You may receive error messages when you use the sp_cursoropen statement to open a cursor on a user-defined stored procedure in SQL Server 2005
913849FIX: No result set is returned when you run an MDX query that uses an unnatural hierarchy in SQL Server 2005
913854You receive an error message when you try to switch to the Neural Network mining model in SQL Server 2005 Analysis Services
913941FIX: A SQL Server login may have more permissions when you log on to an instance of SQL Server 2005
914019FIX: Problems may occur when you use the SQLdiag utility in SQL Server 2005
914233FIX: SQL Server 2005 Analysis Services may close unexpectedly when you create and then delete a subcube in the same session
914535BUG: When you use an ActiveX Data Objects Recordset object to access a database in SQL Server 2005, the Recordset object returns no records
914595FIX: Dimension processing may fail, and you may receive an error message in SQL Server 2005 Analysis Services
914596The incorrect type for the union element is returned when you run XQuery against XML data that contains the union element in SQL Server 2005
914638You receive a NULL value when you use XQuery to retrieve the value of an XML element in SQL Server 2005
914640Error message when you try to convert a string to the XML data type in SQL Server 2005: "Cannot bind to the reserved namespace"
914779You may receive error messages when you use the Configure Distribution Wizard in SQL Server 2005
914780Error message when you try to use a merge publication that you created in SQL Server 2005: "Precomputed partitions cannot be used"
914781Error message when you try to create a new subscription in SQL Server Express: "Invalid column name 'step_uid'."
915047When you try to run a query in a query editor in SQL Server Management Studio, a query in a different query editor runs instead
915050Error 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"
915693The GUIDs for the new schema rowsets in SQL Server 2005 Analysis Services are not included in the Msmd.h file
915698Error message when you change the SQL Server service account for a clustered instance of SQL Server 2005: "The system cannot find the file specified."
915763FIX: The Permissions column for the Audit Schema Object Access event does not populate in SQL Server 2005
915793FIX: You cannot restore the log backups on the mirror server after you remove database mirroring for the mirror database in SQL Server 2005
915845SQL Server Agent jobs fail when the jobs contain job steps that use tokens after you install SQL Server 2005 Service Pack 1

Modification Type:MinorLast Reviewed:9/14/2006
Keywords:kbsql2005sp1fix kbsql2005rssp1fix kbsql2005olapsp1fix kbsql2005nssp1fix kbExpertiseInter kbExpertiseAdvanced kbtshoot kbfix kbinfo KB913090 kbAudDeveloper kbAudITPRO