Here is the list of all the changes in SQL Server engine that has been removed.
http://technet.microsoft.com/en-us/library/ms143729.aspxv
This morning I decided to be a little adventurous and install SharePoint 2010 on SQL 2012 environment and the first thing I noticed is that the installation fails because in SQL 2012 Microsoft has removed [sys].[sp_dboption] system Stored Procedure. This has already been reported as a bug but the response from the MS team was that this is by design and they have deprecated it. No workaround has been provided as of yet but they are working to certify Install SharePoint Service Pack 1. http://www.microsoft.com/en... ......