sysoptions

sysoptions is a fake table queried by sp_options. The columns names are case sensitive.

**Table 20-4: sysoptions**
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: Bit 1 – compiled time options Bit 2 – stored procedure specific options Bit 3 – binary options