SQL
SQL Server SESSIONPROPERTY() Function
Return the session settings for a specified option: