Description

Hello all,
I couldn't find the store procedure sp_dboption within SQL Server 2012 .
while configuring the Reporting Services SharePoint Mode as a Single Server Farm
http://msdn.microsoft.com/en-us/library/gg492276.aspx#bkmk_install_SSRS_sharedservice
I got the error as Could not find stored procedure'sp_dboption' in SQL Server 2012.?
Does this issue will be solve if we install the SharePoint 2010 SP1 update or it is common issue.
Hope to hear soon.
Thanks,
Anil Maharjan

Assign To

Nice. When I tried to install the old SQL Server 2000 Northwind database into SQL Server 2012, I got the error mentioned in this ticket. Fortunately, I didn't have to think too hard to get the script fixed because I found this patch to the Northwind installation script:http://social.msdn.microsoft.com/Forums/en-US/sqlserversamples/thread/cefd8a24-1122-46a2-bba3-0e778d19a9fb

Posted by Microsoft on 1/30/2013 at 2:57 PM

Hello, the sp_dboption stored procedure was deprecated and removed in SQL Server 2012. As a replacement, please use ALTER DATABASE instead. For more info, please refer to the Books Online help topic for sp_dboption (http://msdn.microsoft.com/en-us/library/ms174269(v=sql.105).aspx).

Posted by George Birbilis on 6/1/2012 at 9:39 AM

So what can we do for other software that have the same issue? You've broken MonoX portal (which is closed source but free to use product) and possibly lots of other s/w with that change. Can one create the missing stored procedure by hand? What code should they put in there?

Posted by GBoullot on 5/10/2012 at 1:03 PM

You have first to upgrade Sharepoint to SP1 in order to configure it on SQL 2012: http://support.microsoft.com/kb/2460045