ourguru
asked on
SQL Server 2005 Query
Need a query to read current "min_server_memory" and then set it to "min_server_memory+1"
ASKER
This is a Server Setting updated with sp_configure, I don't know that these values are stored in a table...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Update whatevertable SET min_server_memory=min_serv
However this would need a where clause, if min_server_memory is the primarykey of a table and in such case, I'd assume the value would be a field and you'd want to do something like:
update whatevertable SET value=value=1 where keyfield="min_server_memor
I don't have SQL 2005 on this machine, so I couldn't find the table having this value to see how it is i setup. This is the basic way to do it.