Update Note (04/12/2012): Updated information for using SharePoint 2010 with SQL Server 2012 is posted here
With the RC0 release of SQL Server 2012 I have been seeing more and more people interested in testing it with SharePoint 2010. If you attempt to install SharePoint 2010 with a SQL Server 2012 database you may receive an error message related to a missing stored procedure.
SQL Server 2012 removed the system stored procedure sp_dboptions. This is a required stored procedure for installing SharePoint 2010 RTM. Service pack 1 for SharePoint 2010 does eliminate the dependency for the sp_dboptions stored procedure.
To install SharePoint 2010 on SQL 2012 you will need to ensure that you have the SharePoint 2010 with Service Pack 1 installer or you will need to slipstream the service pack so that it is included in the RTM build of SharePoint.
Check out the following blog post if you need instructions on how to slipstream a service pack into the SharePoint 2010 RTM.
Update 04/06/2012: Check out the TechNet article for configuring SQL 2010 with SharePoint 2010 for AlwaysOn availability groups.