We are currently using SQL 2000 Standard with W2K Standard and the
server has 3Gb of RAM. SQL is currently occupying 1.85Gb of memory
which I believe is the maximum for this version of the OS. I believe I
am at my limitations with my current versions of software. My
questions are:
1) Is the version of SQL Standard actually different than the
Enterprise edition. Will my database run on Enterprise if it runs on
Standard?
2) The same questions goes for the operating system? If my code runs
on W2k Standard will it run on Advanced Server?
Thanks a lot...