I am unable to get SQLServer to use more than the default 1.7GB memory.
The machine has 4GB of RAM but I am getting insufficient memory errors
for SQL Server and when I check task manager the machine is only using
just over 1.8GB and SQLServer is using 1.7GB

-Kevin J. Sexton

MS Sql Server LazyDBA home page