How to Detect an Inactive HTTP Session

The SessionCreateTime and SessionLastTime connection properties can be used to determine if the current connection is within a session context. The HTTP request is not running within a session context when either connection property query returns an empty string.

The SessionCreateTime connection property provides a metric of when a given session was created. It is initially defined when the sa_set_http_option system procedure is called to establish the SessionID.

The SessionLastTime connection property provides the time when the last processed session request released the database connection upon termination of the previous request. It is returned as an empty string when the session is first created until the creator request releases the connection.

SELECT CONNECTION_PROPERTY( 'sessioncreatetime' ) INTO ses_create;
SELECT CONNECTION_PROPERTY( 'sessionlasttime' ) INTO ses_last;