Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer


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

Browse other questions tagged or ask your own question.