Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When creating a new database, ANSI Padding Enabled is set to False by default.

screenshot of New Database dialog

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?

share|improve this question
Most client libraries will set ANSI_PADDING to ON explicitly so the database setting never comes into play. – Martin Smith Nov 19 '13 at 13:39
@MartinSmith interesting link, feel free to post it as an answer quoting that paragraph/table. I understand now, the default setting on DB level is OFF and the default client setting is ON. – Stijn Nov 19 '13 at 13:45
up vote 1 down vote accepted

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.