--- title: "Different ways to identify and change compatibility levels in SQL Server" url: https://daily.dev/posts/different-ways-to-identify-and-change-compatibility-levels-in-sql-server-pejtaonw3 source_url: https://www.sqlshack.com/different-ways-to-identify-and-change-compatibility-levels-in-sql-server/ type: article source: "SQL Shack" published: 2024-07-22T10:32:00.644Z updated: 2024-11-16T02:16:05.657Z tags: ["database", "microsoft-sql-server", "sql"] reading_time: 9 upvotes: 1 comments: 0 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Different ways to identify and change compatibility levels in SQL Server **[SQL Shack](https://daily.dev/sources/sqlshack)** · 9 min read · 1 upvotes · 0 comments ## Summary Compatibility level in SQL Server is a property that determines how the database behaves in terms of syntax and query optimization, allowing for backward compatibility with older versions. Methods to identify and change the compatibility level include using dynamic management views and SQL Server Management Studio, as well as executing the ALTER DATABASE command. New features introduced with different compatibility levels include Query Store, Intelligent Query Processing, and Temporal Tables, among others. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments - [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments - [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments - [CNCF Unveils Schedule for KubeCon \+ CloudNativeCon Europe 2026](https://daily.dev/posts/cncf-unveils-schedule-for-kubecon-cloudnativecon-europe-2026-ikhcoa5cb) · CNCF · 2 upvotes · 0 comments - [CNCF Debuts KubeCon \+ CloudNativeCon Japan 2026 Schedule](https://daily.dev/posts/cncf-debuts-kubecon-cloudnativecon-japan-2026-schedule-xp5pyudub) · CNCF · 1 upvotes · 0 comments --- Tags: [#database](https://daily.dev/tags/database), [#microsoft-sql-server](https://daily.dev/tags/microsoft-sql-server), [#sql](https://daily.dev/tags/sql) [View this post on daily.dev](https://daily.dev/posts/different-ways-to-identify-and-change-compatibility-levels-in-sql-server-pejtaonw3)