Thanks for your reply. I found this article on MSDN -

http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&sd=tech

it says:

SQL Server 2000

Normally, both the SQL Server 2000 Enterprise Edition and SQL Server 2000 Developer Edition can use...

Doesn't it contradict your earlier statement -

"My understanding is that SQL 2000 standard can address 2gb memory. End of story. But, Its wise to have more for the O/S."

I...

Thanks a lot. You are absolutely right. Sql Server 2000 Standard Edition supports only 2GB. We will have tp upgrade to Enterprise Edition to take advantage of the extra memory...