sp_configure Output

The values sp_configure prints vary, depending on your platform and on what values you have already changed.

This output shows the type of information sp_configure prints if your display level is comprehensive, and you execute sp_configure with no parameters:

sp_configure
Group: Configuration Options

Group: Backup/Recovery

Parameter Name        Default Memory Used Config Value Run Value Unit Type
--------------        ------- ----------- ------------ --------- ---- ----
allow remote access         1          0          1         1    switch dyn
print recovery info         0          0          0         0    switch dyn
recovery interval in m      5          0          5         5    minutes dyn
...
Note: All configuration groups and parameters appears in output if your display level is set to “comprehensive.”
where: