Possible to change server from Enterprise Edition to Standard Edition

  • Is it possible to (hopefully easily) change the edition of SQL Server installed on a server?  Someone installed Enterprise Edtion by mistake and I want to get it down to Standard, without having to do a re-install if possible.  I checked the Microsoft site and couldn't find anything.

    Butch Weber

  • This was removed by the editor as SPAM

  • Why not reinstall? It's easy, detach the dbs, script out the logins (sp_help_revlogin) and uninstall. The install std, run the script, attach the dbs.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply