Jo and Carl,

Thanks for the information.

We are using SQL server is Standard edition 32bit and Windows 2003 Standard edition 64 bit.

As per MS article at the link given by Carl,

AWE is not available on all versions of SQL Server 2000. For example, AWE is not available for MSDE, SQL Server 2000 Standard Edition, SQL Server 2000 Personal edition, or installations of only the SQL Server 2000 Tools.

If this is the case, will I not be able to use more than 3 GB on server 1 though I have 8GB RAM as it is SQL server 2000 standard edition?