Question
Which command lists the active SET options for the current connection?
Answer
DBCC USEROPTIONS — DBCC command, session/activity. Returns the current session’s SET option names and values, including ANSI settings, isolation level, language, and date format.