Yep, found the file, changed it and everything is okay now.

Many thanks for all your help.

Frank,

the /3gb switch is not set at all. I can not find a boot.ini file on any of my disks and the awe enabled parameter in sp_configure is set to...

Hi Frank,

thanks for replying so quickly. There is 4gb of memory on the box and I am running SQL Server 2k Enterprise Edition.

That's even better Jonathan, Many thanks!

That's fantastic! Many thanks...