How to configure SQL Server memory allocation

Hello,
I am relatively new to SQL Server. I'm trying to do some
initial tuning of SQL and I went into the "SQL Server
Properties (Configure)" dialog area and clicked
the "memory" tab. I changed the setting to "Use a fixed
memory size". I then read some information and realized
that I did not want to keep this setting. So now I want
to change the memory setting back to "Dynamically
configure SQL Server memory". However, when I do this,
SQL Server won't keep this setting. It defaults back to
fixed every time. Can anyone out there explain to me how
to do this. I've read a little about setting advanced
options with sp_configure, but I don't really understand
and I also don't want to corrupt anything. Please provide
as many details as possible as I am new to SQL Server and
trying to learn!!!!!!
Thanks in advance for any help!!!
Shane Sprouse
GIS Analyst
Greenwood County, SCHi Shane,
Here is the script that you can use to run from Query Analzyer
USE master
go
sp_configure 'show advanced options', 1
go
-- To view the current settings
sp_configure 'min server memory'
go
sp_configure 'max server memory'
go
-- To modify the current settings, change the option that you want
sp_configure 'min server memory', 'new value'
go
sp_configure 'max server memory', 'new value'
go
RECONFIGURE WITH OVERRIDE
go
-- Note: To use a fixed memory size set min server memory = max server
memory
-- By default 'Max Server memory' = 2147483647 (Dynamic)
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.