sysoptions is a fake table queried by sp_options. The columns names are case sensitive.
Name |
Datatype |
Attributes |
Description |
---|---|---|---|
spid |
int |
Contains the process ID. |
|
name |
varchar(100) |
Contains the name of the option. |
|
category |
varchar(100) |
Contains the name of the category to which the option belongs. |
|
currentsetting |
varchar(100) |
NULL |
Contains the current setting of the option. |
defaultsetting |
varchar(100) |
NULL |
Contains the default setting of the option. |
scope |
int |
Contains the bitmap used to capture information about options. The bits are ordered as follows:
|