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

1 comment:

  1. TODAY I GOT MY DESIRED XMAS LOAN AMOUNT $520,000.00 FROM A RELIABLE AND TRUSTED LOAN COMPANY. IF YOU NEED A LOAN NOW EMAIL CONTACT drbenjaminfinance@gmail.com

    Hello, I'm here to testify of how i got my loan from BENJAMIN LOAN FINANCE(drbenjaminfinance@gmail.com) I don't know if you are in need of an urgent loan to pay bills, start business or build a house, they offer all kinds of loan. So feel free to contact Dr. Benjamin Owen he holds all of the information about how to obtain money quickly and painlessly without cost/stress via Email: drbenjaminfinance@gmail.com

    Consider all your financial problems tackled and solved ASAP. Share this to help a soul right now THANKS.

    ReplyDelete