Quick Note: SQL Server 2005 SP3
The Service Pack 3 for SQL Server 2005 is now available as windows Update. That is quite convenient.
But you might want to read the Release Notes first. If something did not work out after you installed SP3, you need to uninstall the whole software.
SQL Server 2005 SP3 Release Notes: