sp_help_set_options reports the current state (ON or OFF) of the SET options in effect for a connection. SET options are those options controlled using the Transact-SQL SET command. SQL Server version 6.5 introduced a new system variable, @@options, which reports the current state of the SET options. @@options, however, only returns an integer value, which is hard for end users to interpret. sp_help_set_options will query @@options and produce an understandable result set indicating the current state of the SET options. It can report on all the SET options, a specific option, or those SET options whose names contain a common string.
sp_help_set_options cannot be run on SQL Server versions prior to 6.5 because it depends on the @@option.
sp_help_set_options is created as a stored procedure in the master database.