SESSIONPROPERTY
Returns the SET options settings of a session.
Syntax
SESSIONPROPERTY ( 'option' )
Arguments
'option''
Is the current option setting for this session. option can be any of the following values:
| Option | Description |
|---|---|
| ANSI_NULLS | Specifies whether the ISO behavior of equals (=) and not equal to (<>) against null values is applied. |
| 1 = ON | |
| QUOTED_IDENTIFIER | Specifies whether ISO rules about how to use quotation marks to delimit identifiers and literal strings are to be followed. |
| 1 = ON | |
| MAXDOP | Specifies what is the maximum degree of parallelism configured for a session. |
| NULL = Input is not valid. |
Return types
sql_variant
Example
SELECT SESSIONPROPERTY ('MAXDOP');