CODEWITHSUNDEEP
sql-server-2005
Nikhil
Nikhil

Reputation: 333

sql server property "maximum server memory" disabled

I want to set the maximum server memory option for a SQL server, but this option is disabled for me. i have logged in through windows authentication, and logged into windows with the administrator user.

you can find this option by right click on DB server -> Select Properties -> Memory tab.

Please see the screenshot of the properties screen in the link alt text

Please let me know how can i change the memory option and why is it disabled for me. am i missing some permission?

Upvotes: 0

Views: 482

Answers (1)

Danny
Danny

Reputation: 2821

Try: USE master EXEC sp_configure 'show advanced option', '1'

then stop and restart the server.

Upvotes: 1

Related Questions