When I execute
sp_configure "current audit table",0, "with truncate"
and then display the current audit table configuration using sp_configure, I noticed the result as below
Parameter Name Default Memory Used Config Value Run Value
current audit table 1 0 0 1
Why is the config value displayed as 0 when the run value is set to 1.
I expected both the values to be 1 as it is the current audit table.
Can someone help me figure this out?