An operator says changing the COMPATIBLE setting is merely a cosmetic version-label change. What should the DBA explain?

Published
  1. Any compatibility change can always be undone without restrictions.
  2. COMPATIBLE is the same as a SQL user's password expiration date.
  3. COMPATIBLE only changes the Azure subscription display name.
  4. Database compatibility settings can affect enabled features and recovery or downgrade options.

Comments — 0