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-us/download/details.aspx?id=26640v
I decided to take the [sp_dboption] from SQL
2008 R2 environment and I also noticed that the built-in functions like DATABASEPROPERTY are also gone. I made a few changes
to the SPROC see code from the link below and was able to successfully install SharePoint
2010
https://skydrive.live.com/redir.aspx?cid=3a35c02c8765e840&resid=3A35C02C8765E840!261&parid=3A35C02C8765E840!152&authkey=!AKwXZrZvEi_O7Isv
** Disclaimer this has not been tested in a production
environment.