Is it possible to perform Sql 7 Enterprise upgrade to Sql 200o Standard Editions

Hi all,

I was curious if there any issues that I need to be aware off in attempting to upgrade an existing client database (Sql Server 7 Enterprise Edition) to Sql 2000 Standard edition. During upgrades are we forced to stay with the same editions or can the upgrade to lower level editions.

Thanks
ZeidNot possible, you need to uninstall and re-install SE.
EE is far superior than SE by any means.

Is it possible to install Enterprise from a Standard Edition CD?

There is only on one CD in my environment and it contains SQL Svr Standard;
however, some installs show as Enterprise Editions - is this possible?No, someone had another CD at some point.
--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"NeverQuit" <NeverQuit@.discussions.microsoft.com> wrote in message
news:BBBDBE3A-0DB9-4F9D-8D4F-582F69EEA963@.microsoft.com...
> There is only on one CD in my environment and it contains SQL Svr
Standard;
> however, some installs show as Enterprise Editions - is this possible?

Is it possible to install Enterprise from a Standard Edition CD?

There is only on one CD in my environment and it contains SQL Svr Standard;
however, some installs show as Enterprise Editions - is this possible?
No, someone had another CD at some point.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"NeverQuit" <NeverQuit@.discussions.microsoft.com> wrote in message
news:BBBDBE3A-0DB9-4F9D-8D4F-582F69EEA963@.microsoft.com...
> There is only on one CD in my environment and it contains SQL Svr
Standard;
> however, some installs show as Enterprise Editions - is this possible?
sql

Is it possible to install Enterprise from a Standard Edition CD?

There is only on one CD in my environment and it contains SQL Svr Standard;
however, some installs show as Enterprise Editions - is this possible?No, someone had another CD at some point.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"NeverQuit" <NeverQuit@.discussions.microsoft.com> wrote in message
news:BBBDBE3A-0DB9-4F9D-8D4F-582F69EEA963@.microsoft.com...
> There is only on one CD in my environment and it contains SQL Svr
Standard;
> however, some installs show as Enterprise Editions - is this possible?