DBCC USEROPTIONS

Return the SET options currently active (set for the current connection.)

Syntax
      DBCC USEROPTIONS [WITH NO_INFOMSGS]

Options:

   NO_INFOMSGS - Suppress all information messages.

Examples

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 commands

SET
SET TRANSACTION ISOLATION LEVEL


 
Copyright © 1999-2024 SS64.com
Some rights reserved