Microsoft SQL Server 2005 Service Pack 2 Download
Microsoft SQL Server 2005 Service Pack 2 download is available for SQL Server professionals.
Microsoft has released Service Pack 2 for the SQL Server 2005. The MS SQL Server 2005 Service Pack 2 (SP2) has been announced on 16th of February 2007.
You can download SQL Server 2005 Service Pack 2 for all editions from Microsoft Downloads portal.
The file size for x86 edition is about 282 MB where on the other hand the size is 340 MB for x64 edition and 392 MB for ia64 edition.
You can view the ReadMe file for the SQL Server Service Pack 2 at ReadmeSQL2005SP2.htm
Also if you wonder what is new with SP2, you can find the official announcement from Microsoft about what is new with Service Pack 2 at WhatsNewSQL2005SP2.htm
The final version numbers for the all MS SQL Server 2005 SP2 products is 9.00.3042
The version numbers of the RTM and the Service Packs of SQL Server 2005 can be listed as:
|SQL Server 2005 Release
|SQL Server 2005 RTM
|SQL Server 2005 SP1
|SQL Server 2005 SP2
During the installation, the process checks whether any application locks SQL Server 2005 files.
To avoid a reboot after installation, you should stop the following SQL Server 2005 services before starting the update of the SQL Server 2005 to Service Pack 2.
SQL Server Reporting Services (SQL2005)
SQL Server Analysis Services (SQL2005)
SQL Server Agent (SQL2005)
SQL Server FullText Search (SQL2005)
SQL Server Browser
SQL Server VSS Writer
SQL Server Integration Services
SQL Server (SQL2005)
You can select the features or the application for upgrading to SP2
For a list of bugs that are fixed in SQL Server 2005 Service Pack 2 download, SQL Server administrators can refer to knowledge base (kb) article KBId 921896
Books OnLine for SQL Server 2005 is also updated with the Service Pack 2.
You should download and install the update package for BOL, SQL Server 2005 Books Online (February 2007) from link Microsoft Downloads (BOL)
The Feature Pack tools are also updated to be used with SP2.
The list of tools available within Feature Pack February 2007 contains;
Microsoft Core XML Services (MSXML) 6.0,
Microsoft OLEDB Provider for DB2,
Microsoft SQL Server Management Pack for MOM 2005,
Microsoft SQL Server 2000 PivotTable Services,
Microsoft SQL Server 2000 DTS Designer Components,
Microsoft SQL Server Native Client,
Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider,
Microsoft SQL Server 2005 Backward Compatibility Components,
Microsoft SQL Server 2005 Command Line Query Utility,
Microsoft SQL Server 2005 Datamining Viewer Controls,
Microsoft SQL Server 2005 JDBC Driver,
Microsoft SQL Server 2005 Management Objects Collection,
Microsoft SQL Server 2005 Compact Edition,
Microsoft SQL Server 2005 Notification Services Client Components,
Microsoft SQL Server 2005 Upgrade Advisor,
Microsoft .NET Data Provider for mySAP Business Suite, Preview Version,
Reporting Add-In for Microsoft Visual Web Developer 2005 Express,
Microsoft Exception Message Box,
Data Mining Managed Plug-in Algorithm API for SQL Server 2005,
Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies,
Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007
For all the list of available tools and updates within Feature Pack February 2007 go to Feature Pack