TechBrothersIT is the blog spot and a video (Youtube) Channel to learn and share Information, scenarios, real time examples about SQL Server, Transact-SQL (TSQL), SQL Server Database Administration (SQL DBA), Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Warehouse (DWH) Concepts, Microsoft Dynamics AX, Microsoft Dynamics Lifecycle Services and all other different Microsoft Technologies.
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
GOALTERDATABASE [Demo] SET COMPATIBILITY_LEVEL = 120
How to Change Database Level Compatibility Level in SQL Server - SQL Server DBA Tutorial