Fwiw, I prefer the a different way to check the current ansi / connection settings, using:

@@OPTIONS

I actually use a table of config values so the code is more readable, but here's the direct value comparison method:

IF @@OPTIONS & 16 > 0

PRINT 'ANSI_PADDING is ON'

ELSE

PRINT 'ANSI_PADDING is OFF'

IF @@OPTIONS & 16384 > 0

PRINT 'XACT_ABORT is ON'

ELSE

PRINT 'XACT_ABORT is OFF'