USE master; 
GO 
EXEC sp_configure 'show advanced option', '1'; 
GO
RECONFIGURE WITH OVERRIDE;
GO
EXEC sp_configure 'max server memory (MB)',8000;
GO
RECONFIGURE WITH OVERRIDE;
GO