DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 913090 - Last Review: November 20, 2007 - Revision: 6.4

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  (http://support.microsoft.com/kb/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:
Collapse this tableExpand this table
910375  (http://support.microsoft.com/kb/910375/ ) FIX: No table headers appear in the Excel report when you use SQL Server 2005 Reporting Services to export information to Excel
910376  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/911912/ ) FIX: You experience low CPU spikes at set intervals even when there is no user activity in SQL Server 2005
911937  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/912136/ ) You may experience problems after you run the Business Intelligence Wizard to add time calculations in SQL Server 2005 Analysis Services
912322  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/912423/ ) FIX: Memory leaks occur when you use Fuzzy Lookup and Fuzzy Grouping to transform a SQL Server 2005 Integration Services package
912429  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/912471/ ) FIX: The replication on the server does not work any longer when you manually fail over databases in SQL Server 2005
912472  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/912702/ ) FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services: "Dimension attribute was not found"
912705  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/912885/ ) FIX: You may receive an access violation error message when you run a parallel execution plan in SQL Server 2005
913363  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/913849/ ) FIX: No result set is returned when you run an MDX query that uses an unnatural hierarchy in SQL Server 2005
913854  (http://support.microsoft.com/kb/913854/ ) You receive an error message when you try to switch to the Neural Network mining model in SQL Server 2005 Analysis Services
913941  (http://support.microsoft.com/kb/913941/ ) FIX: A SQL Server login may have more permissions when you log on to an instance of SQL Server 2005
914019  (http://support.microsoft.com/kb/914019/ ) FIX: Problems may occur when you use the SQLdiag utility in SQL Server 2005
914233  (http://support.microsoft.com/kb/914233/ ) FIX: SQL Server 2005 Analysis Services may close unexpectedly when you create and then delete a subcube in the same session
914535  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/914595/ ) FIX: Dimension processing may fail, and you may receive an error message in SQL Server 2005 Analysis Services
914596  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/914638/ ) You receive a NULL value when you use XQuery to retrieve the value of an XML element in SQL Server 2005
914640  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/914779/ ) You may receive error messages when you use the Configure Distribution Wizard in SQL Server 2005
914780  (http://support.microsoft.com/kb/914780/ ) Error message when you try to use a merge publication that you created in SQL Server 2005: "Precomputed partitions cannot be used"
914781  (http://support.microsoft.com/kb/914781/ ) Error message when you try to create a new subscription in SQL Server Express: "Invalid column name 'step_uid'."
915047  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/915693/ ) The GUIDs for the new schema rowsets in SQL Server 2005 Analysis Services are not included in the Msmd.h file
915698  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/915763/ ) FIX: The Permissions column for the Audit Schema Object Access event does not populate in SQL Server 2005
915793  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/916086/ ) FIX: Errors may be generated in the tempdb database when you create and then drop many temporary tables in SQL Server 2005

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
Keywords: 
kbsql2005sp1fix kbsql2005rssp1fix kbsql2005olapsp1fix kbsql2005nssp1fix kbexpertiseinter kbexpertiseadvanced kbtshoot kbfix kbinfo KB913090
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support