List of the bugs that are fixed in SQL Server 2005 Service Pack 3

Article translations Article translations
Article ID: 955706 - View products that this article applies to.
Expand all | Collapse all

SUMMARY

This article contains information about the bugs that are fixed in Microsoft SQL Server 2005 Service Pack 3 (SP3).

Notes
  • Other fixes that are not documented may be included in the service pack.
  • This list will be updated when 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

In addition to the fixes that are listed below, SQL Server 2005 SP3 contains the hotfixes that were included in cumulative update packages for SQL Server 2005 Service Pack 2 from cumulative update package 1 to cumulative update package 9.
For more information about the cumulative update packages for SQL Server 2005 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
937137 The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released
Note If you are upgrading from SQL Server 2005 SP2 Cumulative Update 10 or from SQL Server 2005 SP2 Cumulative Update 11, you must apply a post-SQL Server 2005 SP3 cumulative update after you upgrade to SQL Server 2005 SP3 to obtain all the fixes.
For more information about the post-SQL Server 2005 SP3 cumulative update, click the following article number to view the article in the Microsoft Knowledge Base:
959195 Cumulative update package 1 for SQL Server 2005 Service Pack 3
Microsoft Knowledge Base articles that describe these hotfixes will be released as they become available.

For more information about the bugs that are fixed in SQL Server 2005 Service Pack 3, click the following article numbers to view the articles in the Microsoft Knowledge Base:
Collapse this tableExpand this table
KB articleTitle
942907FIX: The Wmiprvse.exe host process may stop unexpectedly when you run an application that uses the WMI provider to monitor an instance of SQL Server
956911FIX: A time-out setting is not available for the Web Service task in a Microsoft SQL Server 2005 Integration Services (SSIS) package
958547FIX: The values of the datetime column are not same for the rows that are copied when you copy data to a table by using the GETDATE() function in Microsoft SQL Server 2005
959000FIX: When you validate a publication in a transactional replication, articles that you added after you added a vertical filter to an article are not validated in SQL Server 2005
959001FIX: The Log Reader Agent skips some transactions when the Log Reader Agent runs to replicate transactions for a transactional replication in SQL Server 2005
959003FIX: Only the first command in a transaction is replicated to the subscriber when you set the MaxCmdsInTran parameter of Log Reader Agent to 1 in SQL Server 2005
959006FIX: Database mirroring sessions may stop intermittently in SQL Server 2005
959007FIX: Error message when you use SQL Server Service Broker in SQL Server 2005: "Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 589824"
959008FIX: Error message when you start database mirroring in SQL Server 2005 on a database that is restored or upgraded from SQL Server 2000: "The Service Broker ID for the remote copy of database "<DatabaseName>" does not match the ID on the principal server"
959009FIX: Target endpoints in Service Broker of SQL Server 2005 leak in the valid message exchange pattern where the target sends only the end conversation message
959010FIX: Error message when an application that uses Service Broker sends messages in SQL Server 2005: "The conversation endpoint is not in a valid state for SEND"
959012FIX: When you shrink a database that has the SNAPSHOT transaction isolation level enabled in SQL Server 2005, the shrink operation is not completed successfully
959013FIX: The synchronization process is slow, and the CPU usage is high on the computer that is configured as the Distributor in SQL Server 2005
959015FIX: A conflict with the foreign key constraint occurs when you update the case of the column values in the primary key table or you pad column values in the primary key table in SQL Server 2005
959016FIX: Rows that include a NULL column may not be deleted when you delete rows from a table by using "<ImageColumnName> is NULL" as the condition in the WHERE clause in SQL Server 2005
959017FIX: You receive an incorrect result when you query a column of the varchar(max) data type that contains only one character from a table in SQL Server 2005
959018FIX: You cannot find the SQL Server 2005 performance counters for the instance of Windows Internal Database
959019FIX: You receive an incorrect result when you run a query that uses the LIKE operator in SQL Server 2005
959020FIX: When you use a CASE function that returns constants of the binary data type, some constants are trimmed incorrectly even after you run the SET ANSI_PADDING ON statement in SQL Server 2005
959023FIX: A blocking issue occurs when you run the Merge Agent in SQL Server 2005
959024FIX: When the Merge Agent synchronizes multiple batches of changes, the synchronization may take a long time to finish or the synchronization may expire unexpectedly in SQL Server 2005
959025FIX: Error message when you call a stored procedure that returns a rowset which have the DBPROP_MAXROWS rowset property or the SSPROP_MAXBLOBLENGTH rowset property specified: "The incoming tabular data stream (TDS) protocol stream is incorrect"
959026FIX: Error message when you run a DB2 query that uses the WITH UR query hint in SQL Server 2005 Analysis Services: "OLE DB error: OLE DB or ODBC error: An unexpected token "WITH" was found following "<Query>""
959031FIX: Error message when you try to expand the Catalogs node for a linked server that links to a Teradata Database in SQL Server 2005: "Cannot obtain the schema rowset DBSCHEMA_CATALOGS for OLE DB provider SQL Server for linked server (null)"
959376FIX: Error message when you run the DBCC SHRINKFILE command or the DBCC SHRINKDATABASE command on a server that contains a SQL Server 2008 database: "5205 : DBCC SHRINKFILE: Moving Page <FileId>:<PageId> failed"
960611FIX: An incorrect result is returned when you run a Multidimensional Expressions (MDX) query in Microsoft SQL Server 2005 Analysis Services
967199FIX: The Wmiprvse.exe host process stops responding when you run a SQL Server 2005-based application that sends a Windows Management Instrumentation (WMI) query to the SQL Server WMI provider
Resolutions to the following issues are also included in this cumulative update:
Collapse this tableExpand this table
FIX: A new trace event is logged by any command that aborts a transaction in SQL Server 2005 Analysis Services
FIX: An unexpected error is returned when an aggregation is referenced that has an attribute in a many-to-many dimension in SQL Server 2005 Analysis Services: "file ‘pffilestore.cpp’, line 3311, function ‘PFFileStore::HandleDataPageFault’"
FIX: Redundant indexes are created on datacache objects when the cost estimate indicates that indexes are not required in SQL Server 2005
FIX: The PeriodstoDate() function generates an unhandled exception at Time.All coordinates in SQL Server 2005
FIX: If you install SQL Server 2005 SP1 or SQL Server 2005 SP2 after you add a network card to the same computer, the installation adds a duplicate IP address in the SQL Server network configuration
FIX: In SQL Server 2005, the DTS designer application cannot be started on a Windows Vista-based computer or on a Windows Server 2008-based computer
FIX: You cannot set the breakpoint to the script of an SSIS script task when the current script is shorter than a script in another script task in the same package
FIX: A Transfer Objects task does not transfer assemblies to the destination database in SQL Server 2005
The design time experience of the TransferSQLServerObjects task is improved
FIX: The TransferSQLServerObjects task drops database users during the CopyAllOjbect operation in SQL Server 2005
FIX: The property setting of a TransferSqlServerObjects task cannot be correctly saved in SQL Server 2005
The connection handling with SAP Business Intelligence (BI) designer is improved to avoid "connection timed out" error messages
FIX: Error message when you use the new Essbase provider name: "OLAP error (1260046): Unknown Member PARENT_UNIQUE_NAME used in query"
FIX: A query that contains the "current of" statement receives incorrect results from a heap table because of an incorrect query plan in SQL Server 2005
FIX: When a single partition is rebuilt in SQL Server 2005, statistics are dropped together with the old version of the index
FIX: When a CHECKPOINT thread is blocked by another SPID, SQL Server 2005 does not update the sys.dm_exec_requests dynamic management view with the blocking information, and the blocking_session_id column remains NULL
FIX: You receive an incorrect value in the @@ROWCOUNT function if the query is recompiled
FIX: If the Parameterization Forced option is enabled on a database in SQL Server 2005, the unicode characters inside literal constants in some queries may be interpreted as non-unicode characters
The sp_altermessage stored procedure can now be used to enable or disable system messages to the Windows event log in SQL Server 2005
FIX: When a "non-yielding schedule condition" error (error 17883) occurs, the SQL Server service generates a dump file on the first occurrence
FIX: When multiple instances of the print control are started at the same time from the same Internet Explorer process, Internet Explorer may crash
For more information about SQL Server 2005 Service Pack 3-related issues, click the following article numbers to view the articles in the Microsoft Knowledge Base:
Collapse this tableExpand this table
KB articleTitle
931279SQL Server timing values may be incorrect when you use utilities or technologies that change CPU frequencies
958999Best practices for changing the service account for the report server in SQL Server 2005 Reporting Services
960320Error message when you install SQL Server 2005 Service Pack 3 on Windows Vista: "Visual Studio 2005 has a know compatibility issue with this version of Windows"
959823How to customize the quota for the TokenAndPermUserStore cache store in SQL Server 2005 Service Pack 3

Properties

Article ID: 955706 - Last Review: October 9, 2011 - Revision: 5.0
APPLIES TO
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Express Edition with Advanced Services
  • Microsoft SQL Server 2005 Analysis Services
  • Microsoft SQL Server 2005 Reporting Services
  • Windows Internal Database
Keywords: 
kbsqlsetup kbexpertiseinter kbtshoot kbfix kbsurveynew kbinfo KB955706

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com