sp_configure 顯示或變更目前伺服器的全域組態設定

Usage:

sp_configure [ [ @configname = ] 'option_name' [ , [ @configvalue = ] 'value' ] ]

Example:

# When the config_value and run_value are equal to 1, then this trace is running.

Default trace enabled

列出進階組態選項

USE master;
GO
EXEC sp_configure 'show advanced option', '1';
    
RECONFIGURE;
EXEC sp_configure;

# 變更組態選項

USE master;
GO
EXEC sp_configure 'recovery interval', '3';
RECONFIGURE WITH OVERRIDE;