Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/913089

From BetaArchive Wiki

Article ID: 913089

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



INTRODUCTION

Microsoft distributes fixes in service packs. Service packs keep a product current. They include hotfixes and software updates. Service packs may also include system administration tools, drivers, and additional components. These updates and components are conveniently bundled for easy downloading.

Service packs are cumulative. Each new service pack contains all the fixes that are in previous service packs, together with any new fixes. You do not have to install a previous service pack before you install the latest one. For example, you do not have to install Microsoft SQL Server 2005 Service Pack 1 (SP1) before you install Microsoft SQL Server 2005 Service Pack 2 (SP2).

MORE INFORMATION

Microsoft SQL Server 2005 Service Pack 2

Release date: 5 March 2007

How to obtain

To obtain SQL Server 2005 SP2 for all editions of SQL Server 2005 in an automated way, visit the following Microsoft Update Web site. (These editons include Microsoft SQL Server 2005 Express Edition.)

To obtain SQL Server 2005 SP2, visit the following Microsoft Web site:

To obtain SQL Server 2005 Express Edition SP2, visit the following Microsoft Web site:

To obtain Microsoft SQL Server 2005 Express Edition with Advanced Services SP2, visit the following Microsoft Web site:

Fix list

For a list of the bugs that are fixed in SQL Server 2005 SP2, click the following article number to view the article in the Microsoft Knowledge Base:

921896 A list of the bugs that are fixed in SQL Server 2005 Service Pack 2


Important notes for using Microsoft Update

  • When you use Microsoft Update to install SQL Server 2005 SP2, the installation will be unattended unless components are clustered. If components are clustered, you must follow the prompts to complete the installation.
  • Microsoft Update will upgrade all instances of SQL Server 2005 to SQL Server 2005 SP2. For example, if you have two instances of SQL Server 2005 running on your computer, both instances will be upgraded to SQL Server 2005 SP2.
  • The SQL Server 2005 Express updates will be shown when you do an express scan and will be available as an automatic update. The other editions of SQL Server will be available as a custom update or as an optional update.
  • For more information about Microsoft Update, visit the following Microsoft Web site:

List of new features and improvements

For more information about the new features and improvements in SQL Server 2005 SP2, visit the following Microsoft Web site:

Readme

There are several different readme files for SQL Server 2005 SP2. To read them, visit the following Microsoft Web site:

Microsoft SQL Server 2005 Service Pack 1

Release date: 18 March 2006

How to obtain

To obtain SQL Server 2005 SP1, visit the following Microsoft Web site:

To obtain Microsoft SQL Server 2005 Express Edition SP1, visit the following Microsoft Web site:

To obtain Microsoft SQL Server 2005 Express Edition with Advanced Services SP1, visit the following Microsoft Web site:

Microsoft Update

To obtain SQL Server 2005 SP1 from Microsoft Update, visit the following Microsoft Web site:

Important notes for using Microsoft Update

  • When you use Microsoft Update to install SQL Server 2005 SP1, the installation will be unattended, unless components are clustered. If components are clustered, you must follow the prompts to complete the installation.
  • Microsoft Update will upgrade all instances of SQL Server 2005 to SQL Server 2005 SP1. For example, if you have two instances of SQL Server 2005 running on your computer, both instances will be upgraded to SQL Server 2005 SP1.
  • If you are running SQL Server 2005 on a beta edition of Microsoft Windows Vista, use the download center link to upgrade to SQL Server 2005 SP1. If you try to upgrade to SQL Server 2005 SP1 by using Microsoft Update, you may experience an error that says the certificate is invalid.

SQL Server 2005 Express Edition SP1 is not available from Microsoft Update.

Fix list

For a list of bugs that are fixed in SQL Server 2005 SP1, click the following article number to view the article in the Microsoft Knowledge Base:

913090 A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1


List of new features and improvements

For more information about the new features and improvements in SQL Server 2005 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:

916940 A list of the new features and improvements that are included in SQL Server 2005 Service Pack 1


Readme

There are several different readme files for SQL Server 2005 SP1. To read them, visit the following Microsoft Web site:

Additional releases

Additional releases are available for SQL Server.

Microsoft SQL Server 2005 Express Edition with Advanced Services

Microsoft SQL Server 2005 Express Edition with Advanced Services is a new, free, and easy-to-use version of SQL Server Express. SQL Server 2005 Express Edition with Advanced Services includes more features and makes it easier than ever to start developing powerful data-driven applications for Web development or for local desktop development.

To obtain SQL Server 2005 Express Edition with Advanced Services, visit the following Microsoft Web site:

Microsoft SQL Server 2005 Express Edition Toolkit

Microsoft SQL Server 2005 Express Edition Toolkit provides additional tools and resources for SQL Server 2005 Express Edition and for SQL Server 2005 Express Edition with Advanced Services.

To obtain SQL Server 2005 Express Edition Toolkit, visit the following Microsoft Web site:

Microsoft SQL Server Management Studio Express (SSMSE)

Microsoft SQL Server Management Studio Express (SSMSE) is a free and easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services.

To obtain SQL Server Management Studio Express (SSMSE), visit the following Microsoft Web site:

Note Readme files are available for SQL Server 2005 Express Edition with Advanced Services, for SQL Server 2005 Express Edition Toolkit, and for SQL Server Management Studio Express:

  • ReadmeSSMSE.htm: Readme for SQL Server Management Studio Express
  • ReadmeSQLEXP2005Advanced.htm: Readme for SQL Server 2005 Express Edition with Advanced Services
  • ReadmeSQLEXP2005Toolkit.htm: Readme for SQL Server 2005 Express Edition Toolkit



Additional query words: sql2005sp1fix sql2005sp2fix

Keywords: kbinfo kbtshoot kbservicepack kbgetsp kbexpertiseadvanced kbexpertiseinter KB913089