Presents your 
SQL SERVER E-NEWSLETTER for August 8, 2002

<------------------------------------------->

Identify user session connections

Although the output of @@OPTIONS is not easy to understand, it can be
interpreted to user connections options based on the bit that is set. 
Note that the user options XACT_ABORT, CONCAT_NULL_YIELDS_NULL, and
NUMERIC_ROUNDABORT don't show up in SQL Server 7.0's @@OPTIONS settings.

The following is a script that helps identify in an easier output what
options have been set for the current user session's connection.

PRINT   CASE    WHEN @@OPTIONS | 1    = @@OPTIONS
   THEN 'DISABLE_DEF_CNST_CHK'   ELSE '' END
PRINT   CASE    WHEN @@OPTIONS | 2    = @@OPTIONS
   THEN 'IMPLICIT_TRANSACTIONS'    ELSE '' END
PRINT   CASE    WHEN @@OPTIONS | 4    = @@OPTIONS
   THEN 'CURSOR_CLOSE_ON_COMMIT'    ELSE '' END
PRINT   CASE   WHEN @@OPTIONS | 8    = @@OPTIONS
   THEN 'ANSI_WARNINGS'       ELSE '' END
PRINT   CASE    WHEN @@OPTIONS | 16    = @@OPTIONS
   THEN 'ANSI_PADDING'       ELSE '' END
PRINT   CASE    WHEN @@OPTIONS | 32    = @@OPTIONS
   THEN 'ANSI_NULLS'       ELSE '' END
PRINT   CASE    WHEN @@OPTIONS | 64    = @@OPTIONS
   THEN 'ARITHABORT'       ELSE '' END
PRINT   CASE    WHEN @@OPTIONS | 128    = @@OPTIONS
   THEN 'ARITHIGNORE'       ELSE '' END
PRINT   CASE    WHEN @@OPTIONS | 256    = @@OPTIONS
   THEN 'QUOTED_IDENTIFIER'    ELSE '' END
PRINT   CASE    WHEN @@OPTIONS | 512    = @@OPTIONS
   THEN 'NOCOUNT'          ELSE '' END
PRINT   CASE    WHEN @@OPTIONS | 1024    = @@OPTIONS
   THEN 'ANSI_NULL_DFT_ON'    ELSE '' END
PRINT   CASE    WHEN @@OPTIONS | 2048    = @@OPTIONS
   THEN 'ANSI_NULL_DFT_OFF'    ELSE '' END
PRINT   CASE    WHEN @@OPTIONS | 4096    = @@OPTIONS
   THEN 'CONCAT_NULL_YIELDS_NULL'    ELSE '' END
PRINT   CASE    WHEN @@OPTIONS | 8192    = @@OPTIONS
   THEN 'NUMERIC_ROUNDABORT'    ELSE '' END
PRINT   CASE    WHEN @@OPTIONS | 16384    = @@OPTIONS
   THEN 'XACT_ABORT'       ELSE '' END
GO

----------------------------------------