SQL Server SESSIONPROPERTY() Function

Return the session settings for a specified option:

SELECT SESSIONPROPERTY('ANSI_NULLS');

Definition and Usage

The SESSIONPROPERTY() function returns the session settings for a specified option.

SESSIONPROPERTY( option)

Parameter	Description
option	Required. The option to retrieve the session settings for. Can be one of the following values: ANSI_NULLS ANSI_PADDING ANSI_WARNINGS ARITHABORT CONCAT_NULL_YIELDS_NULL NUMERIC_ROUNDABOUT QUOTED_IDENTIFIER

Works in:	SQL Server (starting with 2008), Azure SQL Database