SQL Server 2008 SP4 contains fixes to issues that have been reported internally, through our customer feedback platforms, and Hotfix solutions provided since SQL Server 2008 Service Pack 4 up to and including Cumulative Update 17. It also includes the MS14-044 update. It is primarily a roll up of Cumulative Updates as it is the last Service Pack for SQL Server 2008. We will not release Cumulative Updates for SQL Server 2008 SP4
You can download it from here.
Below are the list of Service packs release till date. Click on the version number to get redirected to the microsoft download page.
|SQL CODE||SQL Version||RTM (Gold, no SP)||SP1||SP2||SP3||SP4|
|Katmai||SQL Server 2008||10.00.1600.22||10.00.2531||10.00.4000||10.00.5500||10.0.6000.29|