Limit SQLEXPRESS Memory?

Is there some way to limit the amount of memmory grabbed by SQLEXPRESS as there is with SQL 2000? TaskManager shows it taking 1.4 gig on my server. 2 gig total memory in the machine. I'd like to limit it to someting less.

This statement was captured from a trace when i lowered the max memory to 123MB for my development box which is running SQL2K.

exec sp_configure N'max server memory (MB)', 123

I would suspect it to behave similarly on sql express.

|||

Thanks but that produces an error of

The configuration option 'max server memory (MB)' does not exist, or it may be an advanced option.

Any other ideas?

|||

Advanced options are required. The following will set sqlexpress to 700 mb max server memory and then show all settings:

use master
Go
exec sp_configure 'show advanced options', 1;
Go
RECONFIGURE;
GO
exec sp_configure 'max server memory (MB)', 700;
GO
RECONFIGURE;
GO
SELECT * FROM sys.configurations
ORDER BY name ;
GO