Sys.Databases ANSI Settings

With ANSI setting in SQL Server generally being handled on a connection by connection basis, does anyone know what purpose the ANSI settings in sys.databases serve?

• is_ansi_nulls_on
• is_ansi_padding_on
• is_ansi_warnings_on
• is_ansi_null_default_on
• is_concat_null_yields_null_on
• Etc.

The database settings are used only when the API or session does not specify the settings. Modern drivers like SqlClient, ODBC, OLE DB, etc set these options ON automatically by default, although they can be later toggled as needed. Legacy APIs (e.g. DB-LIB) do not specify the settings at all so the database ON setting is used in that case.