SQL Server 2000 Standard upgrade to Enterprise

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mike (anonymous_at_discussions.microsoft.com)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 11:55:45 -0800

We are upgrading from SQL Server 2000 Standard to
Enterprise Edition.

Questions.

(1) We are considering installing SQL Server 2000
Enterprise Edition on a server running Standard. Could
you please tell me what is modicifed, e.g., system tables,
etc.?

(2) If we install SQL Server 2000 Enterprise Edition on a
new server, can we restore the system tables from the
Standard version on the Enterprise Edition?

Thank you.

Relevant Pages

  • Re: Standard to Enterprise
    ... Ekrem Önsoy - SQL Server MVP ... You'll need to uninstall your Enterprise Edition and install a Standard ... >>>I am asking because we had a notification service running for 3 ...
    (microsoft.public.sqlserver.setup)
  • Re: Benchmark for different edition SQL 2000
    ... Please read the links I posted about memory allocation algorithms in SQL Server. ... My concern is how to prevent the SQL server that increase the memory usage continuously? ... Enterprise edition has some distinct features that SE doesn't. ... the memory arrangement is the same between standard and enterprise? ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server Personal Edition
    ... It is my understanding that it comes with Enterprise Edition and not ... >I have SQL Server 2000 running on My Windows 2000 Server. ... > computer running XP Home Edition and I would like to run SQL on it. ... It does come with the Standard version. ...
    (microsoft.public.sqlserver.setup)
  • Re: Standard to Enterprise
    ... You'll need to uninstall your Enterprise Edition and install a Standard Edition from scratch. ... instances of SQL Server services are both Standard Editions or Enterprise ... > different edition of Notification Services. ...
    (microsoft.public.sqlserver.setup)
  • Re: Install SQL Server 2005 Enterprise Edition on XP Problem
    ... You cannot install Enterprise Edition on XP. ... SQL Server 2005 Enterprise System Requirements ... Standard or Developer Edition is fine on XP SP2 ...
    (microsoft.public.sqlserver.setup)