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

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 738739 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 4/25/2012 5:31:04 AM
Access Restriction Public


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

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.

Anil Maharjan
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:
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 (
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: