Can't change Memory in SQL 2K

When I right click on my SQL Server, go to Properties and click on the
Memory tab. I can't change my memory settings. The Slide Bar won't move.
Can't anyone help.Hello,
Not sure what the issue. Instead use SP_CONFIGURE system procedure from
query analyzer to change the memory configuration.
Script:-
USE master
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
Set the maximum amount of memory to 1 GB: (CHnage it based on your
requirement)
USE master
EXEC sp_configure 'max server memory (MB)', 1024
RECONFIGURE WITH OVERRIDE
Display the newly set configuration:
USE master
EXEC sp_configure 'max server memory (MB)'
Set 'show advanced options' back to default:
USE master
EXEC sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE
Thanks
Hari
"John" <bechtj@.co.delaware.pa.us> wrote in message
news:ef8vJ%23wIHHA.1044@.TK2MSFTNGP02.phx.gbl...
> When I right click on my SQL Server, go to Properties and click on the
> Memory tab. I can't change my memory settings. The Slide Bar won't move.
> Can't anyone help.
>|||Strange thing.
Right now it is set to Fixed Memory at 16 Meg. It won't let me slide the bar
over. So I choose Dynamically and hit ok. I went back in and it is back on
fixed memory again. Why would it change back?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%239ogVMxIHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello,
> Not sure what the issue. Instead use SP_CONFIGURE system procedure from
> query analyzer to change the memory configuration.
> Script:-
> USE master
> EXEC sp_configure 'show advanced options', 1
> RECONFIGURE WITH OVERRIDE
>
> Set the maximum amount of memory to 1 GB: (CHnage it based on your
> requirement)
> USE master
> EXEC sp_configure 'max server memory (MB)', 1024
> RECONFIGURE WITH OVERRIDE
>
> Display the newly set configuration:
> USE master
> EXEC sp_configure 'max server memory (MB)'
>
> Set 'show advanced options' back to default:
> USE master
> EXEC sp_configure 'show advanced options', 0
> RECONFIGURE WITH OVERRIDE
>
> Thanks
> Hari
> "John" <bechtj@.co.delaware.pa.us> wrote in message
> news:ef8vJ%23wIHHA.1044@.TK2MSFTNGP02.phx.gbl...
>|||Another thing thats strange. If I go to another Server with Enterprise
Manager, I can configure the memory from there with no troubles.but from the
Server itself I cannot.
And even odder, on the General Tab, it is blank for OS, for Platform,
Processors etc... strange!!
Then even stranger under Processors it has nothing. Should it show the
processors under that tab or do I need to add them?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%239ogVMxIHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello,
> Not sure what the issue. Instead use SP_CONFIGURE system procedure from
> query analyzer to change the memory configuration.
> Script:-
> USE master
> EXEC sp_configure 'show advanced options', 1
> RECONFIGURE WITH OVERRIDE
>
> Set the maximum amount of memory to 1 GB: (CHnage it based on your
> requirement)
> USE master
> EXEC sp_configure 'max server memory (MB)', 1024
> RECONFIGURE WITH OVERRIDE
>
> Display the newly set configuration:
> USE master
> EXEC sp_configure 'max server memory (MB)'
>
> Set 'show advanced options' back to default:
> USE master
> EXEC sp_configure 'show advanced options', 0
> RECONFIGURE WITH OVERRIDE
>
> Thanks
> Hari
> "John" <bechtj@.co.delaware.pa.us> wrote in message
> news:ef8vJ%23wIHHA.1044@.TK2MSFTNGP02.phx.gbl...
>