[dba-SQLServer] sp_configure question

On 20 Aug 2006 at 15:22, Susan Harkins wrote:

> 
> 
> I'm trying to read the cursor threshold value using sp_configure, but I get
> an error on the following:
> 
> EXEC sp_configure 'cursor threshold'
> 
> Although, it's listed in Help, I can't seem to get a read of the value. The
> error says it doesn't exist or that it's an advanced option.

>From the documentation:
"Some options supported by sp_configure are designated as Advanced. By 
default, these options are not available for viewing and changing; setting 
the Show Advanced Options configuration option to 1 makes these options 
available." 

-- 
Stuart