Server Memory Server Configuration Options

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'max server memory', 4096;
GO
RECONFIGURE;
GO

source = http://msdn.microsoft.com/en-us/library/ms178067.aspx