SQL Server 2008 First Service Pack (SP1) is now available. Service Pack 1 (SP1) focused on essential updates only, primarily roll-ups of cumulative updates 1 to 3 and fixes to issues reported through the SQL Server community. SP1 eases deployment and management of Service Packs by introducing Slipstream, Service Pack Uninstall, and Report Builder 2.0 Click Once capability.
List of the bugs that are fixed in SQL Server 2008 Service Pack 1
| KB Article | Title |
|---|---|
| 944390 | FIX: Error message when you connect to a named instance of SQL Server on a client computer that is running Windows Vista or Windows Server 2008: “Specified SQL server not found” or “Error Locating Server/Instance Specified” |
| 955769 | FIX: The Shared Memory protocol for an instance of SQL Server 2008 is always enabled and the VIA protocol for the instance is always disabled after you repair the instance |
| 956021 | FIX: The About, Execute, and Close buttons are missing when you run the Execute Package Utility in the Chinese (Taiwan) version of Microsoft SQL Server 2008 |
| 956031 | FIX: Error message when you estimate the compression on a table in SQL Server 2008: “Subquery returned more than 1 value” |
| 956427 | You cannot add a cluster node when you install SQL Server 2008 Analysis Services and you do not install the SQL Server 2008 Database Engine |
| 958778 | FIX: The default instance name is set incorrectly to SQLEXPRESS when you install SQL Server 2008 Express |
| 959001 | FIX: The Log Reader Agent skips some transactions when the Log Reader Agent runs to replicate transactions for a transactional replication in SQL Server 2005 and in SQL Server 2008 |
| 959025 | FIX: Error message when you call a stored procedure that returns a rowset which has the DBPROP_MAXROWS rowset property or the SSPROP_MAXBLOBLENGTH rowset property specified: “The incoming tabular data stream (TDS) protocol stream is incorrect” |
| 959026 | FIX: Error message when you run a DB2 query that uses the WITH UR query hint in SQL Server 2005 Analysis Services and in SQL Server 2008 Analysis Services: “OLE DB error: OLE DB or ODBC error: An unexpected token “WITH” was found following “<Query>”" |
| 961126 | FIX: Error message when you run a maintenance plan in SQL Server 2008: “The SQL Server Execute Package Utility requires Integration Services to be installed” |
| 961271 | FIX: In a SQL Server 2008 Reporting Services report that contains several levels, some items disappear when you collapse another item |
| 961633 | FIX: A SQL Server 2008 Reporting Services report is displayed incorrectly in Mozilla Firefox if the report is displayed by using the ReportViewer control |
| 962900 | FIX: Error message when you run a query that involves an outer join operation in SQL Server 2008: “Attempting to set a non-NULL-able column’s value to NULL” |
| 963070 | FIX: You cannot edit or debug an SSIS package in BIDS when SQL Server 2008 Enterprise Edition, Standard Edition, Developer Edition, or Evaluation edition is installed without the SSIS feature |
| 963658 | FIX: PAGE compression is removed from a SQL Server 2008 data table after you shrink the database |
| 967470 | FIX: Error message when you perform an update or a delete operation on a table that does not have a clustered index created in SQL Server 2008: “The operating system returned error 1450″ |
| 967984 | FIX: When you process a full-text catalog in SQL Server 2008, the operation stops responding |
| 968587 | FIX: The aggregate value is incorrect when you design a query that contains some entity groups by using the Report Model Query Designer in SQL Server 2008 or in SQL Server 2005 |
| 968599 | FIX: Error message when you try to specify the SQL Server 2008 Reporting Services account as the credential for a report server in SharePoint Central Administration: “Unable to connect to Report Server WMI provider” |
| 968693 | FIX: A query that uses parameters and the RECOMPILE option returns incorrect results when you run the query in multiple connections concurrently in SQL Server 2008 |
| 968829 | FIX: Error message when you try to upgrade an instance of SQL Server 2005 to SQL Server 2008: “Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes” |
| 968830 | FIX: An incorrect version is displayed on the Instance Selection page when you use SQL Server 2008 Setup to upgrade an instance of SQL Server 2008 |
| 968828 | FIX: The system objects may not be checked as expected when you use different policy evaluation modes in SQL Server 2008 |
For full reference of bug list fixed in service pack 1.
You can download SQL Server 2008 SP1 from the Microsoft Download Center.
