sp_show_options

Description

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

Syntax

sp_show_options

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.