• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

SQL 2000 Enterprise

Michael L.

Well Known Member
Do you know if SQL 2000 Enterprise is a supported database for the
Deployment Serer only?

If it is, would you recommend upgrading to it from 6.x? What would you say
is the best and most stable version of SQL to be on?

Thanking you in advance for your "feedback".

Michael Lockwood
IBM iseries 400 / JDEdwards Technical Consultant
Avnet Computer Marketing, Enterprise Solutions Division
w: (416) 256.7567
m: (416) 543.4005
f: (253) 663.9335


Reputable Poster
Michael :

I think that SQL 2000 Enterprise Edition is a little too much for
your Deployment, SQL 2000 Standard runs fine.
SQL 2000 Enterprise will run fine too, but it you will fully exploit it
only if Deployment is W2K Clustered, your C.O. are residing there and
you want their databases to be SQL2K clustered too.
I strongly recommend to upgrade from SQL 6.x; you may either go to
SQL 7 or SQL 2K. If I were you, would go straight to SQL 2K.
It's recommended by JDE on its KG, and it runs fine.
SQL 6.x is definitely a headache.


B7321 to Xe, NT/W2K/SQL
JAS, Interoperability
Grupo ASSA - Application Software SA