• Quite correctly, this implies that ANSI_NULLS is ON by default, and only turned off if that's what you specify.

    John

    I understood the situation to be the opposite--e.g. ANSI_NULLS is OFF by default. The description of the SET ANSI_NULLS command in Books Online appears to agree with that, too.