Tuning SQL Server Configuration - Professional SQL Server 2005 Performance Tuning - page 174

If you run this query, you will get a result similar to the one shown in Figure 7-2.
Figure 7-2
To see the individual running value of any single parameter, such as whether CLR is enabled, you can
run sp_configure on it, as in the following statement:
sp_configure 'clr enabled'
In Figure 7-2, you only see 14 parameters listed. You might expect there should be more. In fact, there
are. We will talk about how to view and change them next.
InspectingAdvancedSettingsandChangingTheirValues
Look closely at Figure 7-2. You can see that the run_value for the Show Advanced Options setting
(row 13) is 0, which means off.
Now run the following statement:
sp_configure 'show advanced options', 1
go