SESSIONPROPERTY

Display the SET options currently set for a session.

Syntax:
      SESSIONPROPERTY ( propertyname )

For boolean values SessionProperty will return 1 for ON or 0 for OFF.

Examples

SELECT SESSIONPROPERTY ('ANSI_NULLS')
SELECT SESSIONPROPERTY ('ANSI_PADDING')
SELECT SESSIONPROPERTY ('ANSI_WARNINGS')
SELECT SESSIONPROPERTY ('ARITHABORT')
SELECT SESSIONPROPERTY ('CONCAT_NULL_YIELDS_ NULL')
SELECT SESSIONPROPERTY ('NUMERIC_ROUNDABORT')
SELECT SESSIONPROPERTY ('QUOTED_IDENTIFIER')
SELECT SESSIONPROPERTY ('CONCAT_NULL_YIELDS_NULL')
SELECT SESSIONPROPERTY ('CONCAT_NULL_YIELDS_NULL')
SELECT SESSIONPROPERTY ('CONCAT_NULL_YIELDS_NULL')
SELECT SESSIONPROPERTY ('CONCAT_NULL_YIELDS_NULL')
SELECT SESSIONPROPERTY ('CONCAT_NULL_YIELDS_NULL')

"Riches do not consist in the possession of treasures, but in the use made of them" ~ Napoleon Bonaparte

Related commands:

SET
DBCC USEROPTIONS