Shifting from Standard to Enterprise Edition(SQL Server 2000)

• U J

  SSCrazy

  Points: 2423

  More actions

  November 17, 2006 at 7:34 am

  #171093

  dear all,

  i m having SQL Server 2000 Standard Edition on my production server.

  now i want to deinstall Standard Edition and install Enterprise Edition

  but this is production server and i want to retain all databases,Logins,Users,Jobs and maintainance plans as they are in the Standard Edition [?].

  Please can anybody tell me wht should i do?

  wht will be the Plan Of Action ? [?]

  [] Tnks a lot in advance []

  -Tushar

• Balmukund

  SSCertifiable

  Points: 6648

  More actions

  November 17, 2006 at 7:52 am

  #672599

  Why don't you go with in-place upgarde?

  there is no need to Uninstall-Reinstall.

  Refer "Upgrading an Existing Installation of SQL Server" topic from SQL 2000 Books-online