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.

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


© Copyright SS64.com 1999-2014
Some rights reserved