How to get current connection settings

Posted by Peter Larsson on SQL Team See other posts from SQL Team or by Peter Larsson
Published on Sat, 20 Mar 2010 19:53:32 GMT Indexed on 2010/03/20 21:11 UTC
Read the original article Hit count: 500

SELECT name AS Setting,
        CASE
            WHEN @@OPTIONS & number = number THEN 'ON'
            ELSE 'OFF'
        END AS Value
FROM    master..spt_values
WHERE   type= 'SOP'
        AND number > 0

© SQL Team or respective owner