sp_show_options

Prints all the server options that have been set in the current session.

Syntax

sp_show_options

Examples

Usage

@@options the array of bits corresponding to server options. For every option, “low” is the byte number in @@options, and “high” is the bit within that byte corresponding to the option. If the bit is set, print name of that option.

Permissions

Any user can execute sp_show_options. Permission checks do not differ based on the granular permissions settings.