if you have small memory on your computer (server), the best solution is to adjust SQL Server memory and make it FIXED
so in Enterprise manager do this:
1- right clcick on your server and choose (properties)
2- go to memory tab
3- check on (use a fixed memory size) and alocate it in trackbar under it ... and a number is writen beside (use a fixed memory size) indicate how much memory you use
4- do not check on (Reserve physical memory for SQL Server)
by the way you can change (Minimum query memory) to 512 if you need, but it is not recommended.
i hope this help u
Alamir Mohamed
Alamir_mohamed@yahoo.com