2> CREATE TABLE #config_out
3> (
4> name_col varchar(50),
5> minval int,
6> maxval int,
7> configval int,
8> runval int
9> )
10>
11> INSERT #config_out
12> EXEC sp_configure
13>
14> SELECT * FROM #config_out
15> GO
(15 rows affected)
name_col minval maxval configval runval
-------------------------------------------------- ----------- ----------- ----------- -----------
allow updates 0 1 1 0
clr enabled 0 1 0 0
cross db ownership chaining 0 1 0 0
default language 0 9999 0 0
max text repl size (B) 0 2147483647 65536 65536
nested triggers 0 1 1 1
remote access 0 1 1 1
remote admin connections 0 1 0 0
remote login timeout (s) 0 2147483647 20 20
remote proc trans 0 1 0 0
remote query timeout (s) 0 2147483647 600 600
server trigger recursion 0 1 1 1
show advanced options 0 1 0 0
user instances enabled 0 1 1 1
user options 0 32767 0 0
(15 rows affected)