Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


SQL Server 2000

Contains an entry for each of the current configuration options. In addition, this table contains four entries that describe the configuration structure. syscurconfigs is built dynamically when queried by a user. For more information, see sysconfigures.

Column name Data type Description
value int User-modifiable value for the variable (being used by Microsoft® SQL Server™ only if RECONFIGURE has been executed).
config smallint Configuration variable number.
comment nvarchar(255) Explanation of the configuration option.
status smallint Bitmap indicating the status for the option. Possible values include:

0 = Static (The setting takes effect when the server is restarted.).
1 = Dynamic (The variable takes effect when the RECONFIGURE statement is executed.).
2 = Advanced (The variable is displayed only when the show advanced option is set.).
3 = Dynamic and advanced.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft