Running Lync 2010 with a SQL Server 2012 Backend
Recently I was tasked with migrating all SQL 2008 R1 and prior databases to SQL 2008 R2 and SQL 2012. One of my qualifying applications was Lync 2010. We were under the impression that SQL 2012 would be fine for the Lync 2010 installation. After migrating the database and updating the connections, Lync would not fully initialize.
After running a quick trace, I discovered that some of the Lync processes were calling sp_dboption. SQL Server 2012 does not have this stored procedure any longer. So to remedy the situation, I scripted sp_dboption from the system procedures on SQL 2008 R1 and manually created it on SQL 2012 as a user stored procedure. After granting execute permissions to the user, Lync 2012 started right up.
We've been running on SQL Server 2012 for months without further issue.