SQL Server 2005 Service Pack

SQL Server 2005 Service Pack 1
http://www.microsoft.com/downloads/details.aspx?familyid=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&displaylang=en

SQL Server 2005 Cumulative hotfix package (Build 2153)http://support.microsoft.com/kb/918222/
Accroding to the document,
- We must install each component package for your operating system
- We must enable the SQL Server Management Object (SMO) and SQL Server Distributed Management Object (SQL-DMO) extended stored procedures before You must enable the SQL Server Management Object (SMO) and SQL Server Distributed Management Object (SQL-DMO) extended stored procedures before you install the hotfix package install the hotfix package
- We must install all component packages in the order in which they are listed in this articleelse we may receive an error message.SQL Server 2005Microsoft SQL Server 2005 Analysis ServicesMicrosoft SQL Server 2005 Integration ServicesMicrosoft SQL Server 2005 Notification ServicesMicrosoft SQL Server 2005 Reporting ServicesSQL Server 2005 Tools

More information about SQL Server 2005 cumulative hotfix package

SQL Server 2005 migration

Lot of people ask how we going to migrate SQL Server 6.5, SQL Server 7, SQL Server 2000 to SQL Server 2005

If you still using SQL Server 6.5, you can't direct upgrade to SQL Server 2005. You will need to perform 2 step job. First update SQL Server either to SQL 7 or SQL 2000 and then upgrade to SQL 2005

If you using SQL Server 7.0 or SQL server 2000, you have have few method for migration
1. Side by side migration using Copy database wizard
2. Backup and Restore
3. Attached and detach
4. direct upgrade from SQL 2000 to SQL 2005 (Only applicable for SQL 2000)