Home Dashboard Directory Help
Search

Could not find stored procedure'sp_dboption' in SQL Server 2012.? by Anil Maharjan


Status: 

Closed
 as By Design Help for as By Design


2
0
Sign in
to vote
Type: Suggestion
ID: 738739
Opened: 4/25/2012 5:31:04 AM
Access Restriction: Public
0
Workaround(s)
view

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
Details
Sign in to post a comment.
Posted by Shawn Eary on 3/29/2013 at 11:08 PM
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
Sign in to post a workaround.