Deprecated Database Engine Features in SQL 2008 R2

Every time a new SQL Version is coming to the market people are interested in the new features. I did the same like, 'My favorite top 10 Features of SQL 2008 R2' However, it is also important to know which features are not supported anymore. In the upgrade from SQL 2008 to SQL 2008 R2 most changes are done in the BI stack. The database engine is not changed so much. You can see this when you look to the available database compatibility levels. For SQL 2008 R2, there is no new database compatibility level introduced. After your upgrade to SQL 2008 R2 your database will still stay on compatibility level 100 (SQL2008)

Here you can find a full list of all deprecated database engine features in SQL 2008 R2