How to Change Compatibility Level of a Database & Why Do We need to Do that in SQL Server - DBA Tutorial

In this video you will learn how to change SQL Server Database compatibility using SQL Server Management Studio as well as using T-SQL Script. It also talk about changing compatibility of database using Store procedure. Video explain why it is necessary to change compatibility of a database and gives different scenarios where you have to change database compatibility.

Change Compatibility Level of a Database by using Script

USE [master]
GO
ALTER DATABASE [Demo] SET COMPATIBILITY_LEVEL = 120
GO

How to Change Database Level Compatibility Level in SQL Server - SQL Server DBA Tutorial