Tech4Him – Technology with Integrity

A Christian technology chaos wrangler and his thoughts

SQL Server 2008 Service Pack 1 Now Available

Posted by Tom On April - 23 - 2009

Not sure how I missed this on 4/7/2009, but SP1 is now available for SQL Server 2008. Important to some are change to the deployment and management options of the SP.

  • Slipstream – You are now able to integrate the base installation with service packs (or Hotfixes) and install in a single step.
  • Service Pack Uninstall – You are now able to uninstall only the Service Pack (without removing the whole instance)
  • Report Builder 2.0 Click Once capability

Beware, known issues to check BEFORE installing.  ;)

KB ID Summary

956139
Visual Studio 2008 SP1 may be required for SQL Server 2008 installations

956718
FIX: A MERGE statement may not enforce a foreign key constraint when the statement updates a unique key column that is not part of a clustering key that has a single row as the update source in SQL Server 2008

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

956005
The status indicator for a SQL Server 2008 mirror database differs from SQL Server 2005

955949
Cluster upgrade to SQL Server 2008 fails when SQL Server 2005 cluster nodes have different installed features

955396
How to troubleshoot SQL Server 2008 Setup issues

956138
You cannot upgrade a non-English instance of SQL Server 2000 Reporting Services to SQL Server 2008 Reporting Services

955399
If upgrade to SQL Server 2008 fails, uninstall the upgrade before retrying the upgrade

955973
You might receive this error message when you try to upgrade to SQL Server 2008 on a computer that is running Windows Server: “Access to the path ‘<Path>\perf-MSSQL$SQL2008sqlctr.dll’ is denied”

955389
How SQL Server 2008 updates what feature usage data to collect


Popularity: 4% [?]

Share and Enjoy:
  • Print
  • Digg
  • del.icio.us
  • Facebook
  • Google Bookmarks
  • email
  • LinkedIn
  • PDF
  • RSS
  • Slashdot
  • StumbleUpon
  • Technorati
  • Twitter

Leave a Reply