Article ID: 913090
Article Last Modified on 11/20/2007
APPLIES TO
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Standard X64 Edition
- Microsoft 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 Edition
- 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:
| 910375 | FIX: No table headers appear in the Excel report when you use SQL Server 2005 Reporting Services to export information to Excel |
| 910376 | FIX: 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 |
| 910414 | FIX: 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 |
| 910416 | FIX: Error message when you run certain queries or certain stored procedures in SQL Server 2005: "A severe error occurred on the current command" |
| 910418 | FIX: 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 |
| 911912 | FIX: You experience low CPU spikes at set intervals even when there is no user activity in SQL Server 2005 |
| 911937 | FIX: 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 |
| 912001 | FIX: Error message when you design aggregations in the Aggregation Design Wizard in SQL Server 2005 Analysis Services: "Internal error an unexpected exception occurred" |
| 912016 | FIX: 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" |
| 912017 | FIX: 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." |
| 912021 | FIX: 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 |
| 912136 | You may experience problems after you run the Business Intelligence Wizard to add time calculations in SQL Server 2005 Analysis Services |
| 912322 | FIX: 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 |
| 912419 | FIX: 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 |
| 912422 | FIX: 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 |
| 912423 | FIX: Memory leaks occur when you use Fuzzy Lookup and Fuzzy Grouping to transform a SQL Server 2005 Integration Services package |
| 912429 | FIX: 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" |
| 912439 | FIX: 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" |
| 912446 | FIX: 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 |
| 912450 | FIX: You may receive a null value for a calculated member when you run an MDX query in SQL Server 2005 Analysis Services |
| 912459 | FIX: Error message when you query data from a SQL Server 2005 Analysis Services database by using the HTTP protocol: "Xml Parsing failed" |
| 912471 | FIX: The replication on the server does not work any longer when you manually fail over databases in SQL Server 2005 |
| 912472 | FIX: 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 |
| 912702 | FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services: "Dimension attribute was not found" |
| 912705 | FIX: 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" |
| 912885 | FIX: You may receive an access violation error message when you run a parallel execution plan in SQL Server 2005 |
| 913363 | FIX: You receive an error message when you use SQL Server 2005 Reporting Services to run a report that has two or more parameters |
| 913371 | FIX: 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 |
| 913849 | FIX: No result set is returned when you run an MDX query that uses an unnatural hierarchy in SQL Server 2005 |
| 913854 | You receive an error message when you try to switch to the Neural Network mining model in SQL Server 2005 Analysis Services |
| 913941 | FIX: A SQL Server login may have more permissions when you log on to an instance of SQL Server 2005 |
| 914019 | FIX: Problems may occur when you use the SQLdiag utility in SQL Server 2005 |
| 914233 | FIX: SQL Server 2005 Analysis Services may close unexpectedly when you create and then delete a subcube in the same session |
| 914535 | BUG: When you use an ActiveX Data Objects Recordset object to access a database in SQL Server 2005, the Recordset object returns no records |
| 914595 | FIX: Dimension processing may fail, and you may receive an error message in SQL Server 2005 Analysis Services |
| 914596 | The incorrect type for the union element is returned when you run XQuery against XML data that contains the union element in SQL Server 2005 |
| 914638 | You receive a NULL value when you use XQuery to retrieve the value of an XML element in SQL Server 2005 |
| 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" |
| 914779 | You may receive error messages when you use the Configure Distribution Wizard in SQL Server 2005 |
| 914780 | Error message when you try to use a merge publication that you created in SQL Server 2005: "Precomputed partitions cannot be used" |
| 914781 | Error message when you try to create a new subscription in SQL Server Express: "Invalid column name 'step_uid'." |
| 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 |
| 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" |
| 915693 | The GUIDs for the new schema rowsets in SQL Server 2005 Analysis Services are not included in the Msmd.h file |
| 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." |
| 915763 | FIX: The Permissions column for the Audit Schema Object Access event does not populate in SQL Server 2005 |
| 915793 | FIX: You cannot restore the log backups on the mirror server after you remove database mirroring for the mirror database in SQL Server 2005 |
| 915845 | SQL Server Agent jobs fail when the jobs contain job steps that use tokens after you install SQL Server 2005 Service Pack 1 |
| 916086 | FIX: Errors may be generated in the tempdb database when you create and then drop many temporary tables in SQL Server 2005 |
Additional query words: fixlist sql2005sp1fix
Keywords: kbinfo kbtshoot kbfix kbexpertiseadvanced kbexpertiseinter kbsql2005olapsp1fix kbsql2005rssp1fix kbsql2005nssp1fix kbsql2005sp1fix KB913090
