Enterprise vs Standard edition

Hello,
I installed sql server 2000 Enterprise edition on one of
my servers. It is currently being used. I found out today
that I was supposed to use Standard edition due to
licensing.
Is there any way to back down to Standard edition without
uninstalling and reinstalling?
Thanks
Steve
Hi,
No , you cant. Only way is to remove Enterprise edition and install Standard
edition. But the other way is possible.
THanks
Hari
MCDBA
"Steve" <ee07@.yahoo.com> wrote in message
news:cfcb01c48aa7$f19e4730$a401280a@.phx.gbl...
> Hello,
> I installed sql server 2000 Enterprise edition on one of
> my servers. It is currently being used. I found out today
> that I was supposed to use Standard edition due to
> licensing.
> Is there any way to back down to Standard edition without
> uninstalling and reinstalling?
> Thanks
> Steve
|||Nope. You can upgrade from Standard to Enterprise, but you can't downgrade.
Uninstall and reinstall is the only way unfortunately. You can backup your
databases from Enterprise and restore them on Standard though.
Jacco Schalkwijk
SQL Server MVP
"Steve" <ee07@.yahoo.com> wrote in message
news:cfcb01c48aa7$f19e4730$a401280a@.phx.gbl...
> Hello,
> I installed sql server 2000 Enterprise edition on one of
> my servers. It is currently being used. I found out today
> that I was supposed to use Standard edition due to
> licensing.
> Is there any way to back down to Standard edition without
> uninstalling and reinstalling?
> Thanks
> Steve
sql