Return the SET options currently active (set for the current connection.)
Syntax
DBCC USEROPTIONS [WITH NO_INFOMSGS]
Options:
NO_INFOMSGS - Suppress all information messages.
Example
DBCC USEROPTIONS
“Eventually, all things merge into one, and a river runs through it. The river was cut by the world's great flood and runs over rocks from the basement of time” ~ Norman Maclean, A River Runs Through It
Related:
SET
SET TRANSACTION ISOLATION LEVEL