Link to home
Start Free TrialLog in
Avatar of ourguru
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"
Avatar of SStory
SStory
Flag of United States of America image

if this value is in a table and you know its name and have permissions, you could do the query like this, o

Update whatevertable SET min_server_memory=min_server_memory+1

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_memory"

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.
Avatar of ourguru
ourguru

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
Avatar of ksaul
ksaul

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial