Microsoft has agreed to release the last Service Pack SP4 for SQL 2005 in the fourth quarter of this year 2010.
SP2 for SQL Server 2008 is also expected in the third quarter.
http://blogs.msdn.com/sqlreleaseservices/archive/2010/02/12/sql-server-servicing-plans.aspx