Wooohooo it worked. All that lovely memory chewed up

I've added the /3GB SWITCH not sure it did anything.

Thanks

will

Where is the boot.ini file?

Ok stupid question ...

multi(0)disk(0)rdisk(0)partition(2)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /PAE /NoExecute=OptOut

Ok so do I...

Thanks guys. This really had me stumped.

Bottom line :

If you run the query using the "group by" clause it returns different results than if you run it displaying all the results.

Date2 should have...

You can do something like this :

Select SALSTERR  + ' - ' + case substring(LOCNCODE,4,1) when 'C' THEN 'Aeroton'

   WHEN 'Q' THEN 'Isando'

  ELSE 'OTHER' END AS AREA,*

 from SOP10200

However,...

I totally agree. Very badly phrased question. I also chose 8gb. It should have been something like "Whats the most memory you can install without setting the switch" and I...