What is the best way to downgrade SQL Server 2005 Enterprise Edition to Standard Edition?

Posted on 2007-10-16
Last Modified: 2012-06-21
Hi all--I'm looking for the cleanest way to downgrade a SQL Server 2005 Enterprise Edition SP2 to Standard Edition.  Is it possible to do this downgrade without actually uninstalling and reinstalling?

Note: I've been finding a reference or two on Google to two stored procedures which don't seem to be documented:


They aren't part of the master or msdb databases, so I'm wondering if they're tools found elsewhere.  Where can I find more information on how to load and execute them?

Question by:jkv10
    LVL 18

    Accepted Solution

    ... never heard of those procs ...

    I would go for reinstalling.
    Make sure to detach databases first, so you can attach them once the reinstall completes.
    ... or take backups.

    Hope this helps ...
    LVL 18

    Expert Comment

    Glad I could be of any help ... sorry there is no easy way to go ...

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now