Tag: sql server sessionproperty

SQL SESSIONPROPERTY Function

Example

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.

Syntax

SESSIONPROPERTY(option)

Continue reading SQL SESSIONPROPERTY Function