When creating a new database, ANSI Padding Enabled is set to False by default.
According to this however, the default is ON (which I assume is the same as True). They also recommend to set it to ON and mention that in the future this setting will be deprecated and always set to ON.
I'm quite confused by all of this, actually my question comes from a ticket I have opened that is related to this setting.
So, what is the actual default value, and do I need to change any settings?