SQL Server 2008 Discontinued Features list of features that are no longer available :

1. sp_addalias
2. Registered Servers API
3. DUMP statement
4. LOAD statement
5. BACKUP LOG WITH NO_LOG
6. BACKUP LOG WITH TRUNCATE_ONLY
7. BACKUP TRANSACTION
8. 60, 65, and 70 compatibility levels
9. DBCC CONCURRENCYVIOLATION
10. sp_addgroup
11. sp_changegroup
12. sp_dropgroup
13. sp_helpgroup
14. Northwind and pubs
15. Surface Area Configuration Tool
16. sp_makewebtask
17. sp_dropwebtask
18. sp_runwebtask
19. sp_enumcodepages