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 USEROPTION

__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)