MS SQL Change server configuration parameter

** Myself

Change server configuration parameter

Display parametter

EXEC sp_configure

Display all parametter

EXEC sp_configure 'show advanced option', 1

RECONFIGURE WITH OVERRIDE

EXEC sp_configure

Change parametter run_value

EXEC sp_configure 'max server memory', '400';

EXEC sp_configure

Change parametter config_value and run_value

EXEC sp_configure 'max server memory', '400';

RECONFIGURE WITH OVERRIDE

EXEC sp_configure

Query configure parameter

SELECT value, config, substring (comment,1,50) "DeSName" ,status from master..syscurconfigs  order by desname

go

sp_configure

Column	Description
name	The name of the server configuration
minimum	The minimum value of the configuration option
maximum	The maximum value of the configuration option
config_value	The value to which the server configuration was last set.
run_value	The run-time value of the configuration. Some server configurations do not take effect until the SQL Server service has been restarted. Therefore, if you see aconfig_value that is different from the run_value, this indicates that the SQL