web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / sql server 2012 error ...
Microsoft Dynamics RMS (Archived)

sql server 2012 error 'sp_dboption'

(0) ShareShare
ReportReport
Posted on by HaiLam 347

Install sql 2012 and service pack 1, sql 2005 backward compatible with RMS 2.0 and all service packs 1,2,3, 4 plus the feature 1 and 2. When I restore the database, it pop up the error message (could not find stored procedure 'sp_dboption'. Any suggestion to fix this issue? thx
Hai Lam

*This post is locked for comments

I have the same question (0)
  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at

    At this time, we are not recommending installing SQL2012 for RMS.  Go back to 2008 R2.

    Also, there is no need to install all of the SP and FP.  FWIW, we install SQL2k8R2 and the latest BC and set it up.

    Then install the base RMS SO/HQ package, then 2.0.0155 FP1, 2.0.0155 SP4. 2.0.100 FP2 and the latest hotfix 2.0.1006

  • HaiLam Profile Picture
    HaiLam 347 on at

    Jeff,  thank you for your response.  That is the way I expect to work with.  This is a test of sql 2012 with Rms 2.0.  MS advice me to buy sql 2012 then downgrade to sql 2008r2 if not compatible, and I did that.

    Thanks again for suggestion,

    Hai Lam

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    That error message you got, you did not install SP or FP properly or didn't get installed on your PC. I have tested without installing SP or FP and I got that error message. After I install all SP and FP, it works!

    My version is 2.0.2002 (SP4, FP1,2 and CU5+CU5 Hotfix)

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    you are receiving this message because SP_DBOPTION is retired and was taken out of SQL 2012.  

    Suggest you either update to CU5 or don't use 2012.  All my RMS customers are currently on 2008R2 with no plans to update.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans