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