Thanks Gail. Does that mean to access the available memory we'll have to make the AWE tweak and be running the SQL Server Enterprise edition? i.e. Standard won't work.
The OS version is Windows 2003 Server 64-bit. We currently run SQL Server 2000 32-bit. I'd like to upgrade to a later version but have just found out our 32-bit...