Listing 1: Code To Translate a syscacheobjects.setopts Value into a List of SET Options
DECLARE @sets int
SELECT @sets = 4347

IF @sets & 1 = 1 PRINT 'ANSI_PADDING'
IF @sets & 4 = 4 PRINT 'FORCEPLAN'
IF @sets & 8 = 8 PRINT 'CONCAT_NULL_YIELDS_NULL'
IF @sets & 16 = 16 PRINT 'ANSI_WARNINGS'
IF @sets & 32 = 32 PRINT 'ANSI_NULLS'
IF @sets & 64 = 64 PRINT 'QUOTED_IDENTIFIER'
IF @sets & 128 = 128 PRINT 'ANSI_NULL_DFLT_ON'
IF @sets & 256 = 256 PRINT 'ANSI_NULL_DFLT_OFF'
IF @sets & 4096 = 4096 PRINT 'ARITHABORT'