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

*****************************************************************************************
* How to Change Compatibility Level of a Database in SQL Server *
*****************************************************************************************
How to change Compatility level of a database and why do we need to do that?

1. What is Compatibility Level?
2. Why do we need to change compatibility?
3. Using SQL Server management studio
4. Using T-SQL script

/****************************************************/
SQL Server Version DB Engine Default Supported
Version Compatibility Compatibility Levels
Level
SQL Server 2019 15 150 150, 140, 130, 120, 110, 100
SQL Server 2017 14 140 140, 130, 120, 110, 100
SQL Server 2016 13 130 130, 120, 110, 100
SQL Server 2014 12 120 120, 110, 100
SQL Server 2012 11 110 110, 100, 90
SQL Server 2008 R2 10.5 100 100, 90, 80
SQL Server 2008 10 100 100, 90, 80
SQL Server 2005 9 90 90, 80
SQL Server 2000 8 80 80

/*************Change Compatibility Level of a Database by using Script**************/

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

Note : Flow the Process shown in video.

😉Subscribe and like for more videos:
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link :

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description.

#ChiragsTutorial
#DBATutorial
#DBATutorialLearning
#DBAEducation
#DBATutorialFree
#DatabaseTutorial
#SQLServerDatabaseTutorial
#SQLServerDBATutorial
#MicrosoftSQLServerDatabaseTutorial
#ChiragsDBATutorial
#ChiragsDatabaseTutorial
#ChiragsSQLServerDatabaseTutorial
#ChiragsSQLServerDBATutorial
#ChiragsMicrosoftSQLServerDatabaseTutorial
#CreateDatabaseinSQLServer
#CreateDatabasewithT-SQL
#SQLServerCompatibiltyLevel