What is the default value of ANSI Padding Enabled, and what should value should I set it to? 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?
Per @MartinSmith's comment, the database setting is overwritten by the connection setting most of the times.

ADO.NET, ODBC, OLE DB and SSMS all set this to ON. Additional libraries/tools and settings are listed here.