---

• Back to Microsoft SQL

---

open command line and enter

sqlcmd -S ServerName -U sa -P PASSWORD FOR SQL SA USER –A
sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘max server memory’, 4096; 1GB=1024
GO
RECONFIGURE;
GO