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

6 comments:

  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
  2. Good day. I am a private loan lender that gives out both business and personal loans to individual at a low interest rate of 2% no matter your location. If you are interested Contact me (Whats App) number:+917310847059 sumitihomelend@gmail.com Mr. Sumiti

    ReplyDelete
  3. I will always recommend Mr. James and his team anytime, anywhere when it comes to Cryptocurrency recovery of any type, He saved me from a horrible mistake, I was manipulated in to investing 23.6 BTC on a fraudulent Investment company little did I know that I was being fooled and scammed online even after I made some reports to my banks and the cops but they could not help out, only then I got a connection with jamesmckaywizard, he came to my aid he helped me to recover all my money back from the Scam company and he gave me maximum online security that blocked all scammers and unverified companies from contacting me again. Why not Contact Mr. James/his team and explain your situation to him Via Email: jamesmckaywizard@gmail.com or WhatsApp: ‪+91 87989 06778 ‬…

    ReplyDelete


  4. HOW TO RECOVER MONEY LOST TO FAKE INVESTMENTS- CAPTAIN WEBGENESIS.

    Most of the significant number of cryptocurrency investors who participate in Bitcoin investments ultimately become victims of fraud. I invested $104,000 worth of cryptocurrencies after using up all of my savings. I was ultimately duped and lost every penny to the fraudulent enterprise. Although I was incredibly uncomfortable, I was fortunate to find CAPTAIN WEBGENESIS, a reputable and trustworthy bitcoin hacker group. I got in touch with the expert right away through Email (Captainwebgenesis@hackermail.com) and gave him all the information he needed. In just 72 hours, CAPTAIN WEBGENESIS was able to get back $96,300 of my money that I had lost. Despite the fact that not all of my money was returned, I remained satisfied. I wholeheartedly endorse CAPTAIN WEBGENESIS to any victim in search of a reputable hacker to recover your lost investments and have your funds recovered back.
    WHATSAPP; +1 205 3361020.

    Website; Www.captainwebgenesis.com.

    ReplyDelete
  5. QUICK EASY EMERGENCY URGENT LOANS LOAN OFFER EVERYONE APPLY NOW +918929509036 financialserviceoffer876@gmail.com Dr. James Eric

    ReplyDelete
  6. How To Recover Your Lost Bitcoin With Captain WebGenesis.

    Have you by any means invested your hard earned funds or Bitcoin with an Investment Scheme and later you find out you  have been duped, and you would wish to track down and recover your funds. Captain WebGenesis is a Cyber skilled Expert with special skills to help Scam victims recover their lost Bitcoin. The Expert contains all computer programs required to complete Recoveries from the start till you recover all your funds. Captain WebGenesis also specializes with Credit repair, have all the issues dealing with your poor credit score dealt with. Get in touch with Captain WebGenesis through the Email below;  
    Add; Captainwebgenesis@ hackermail. com
    Website Link; Www.captainwebgenesis.com

    ReplyDelete