There are many methods to know the compatibility levels of a database.
1) Use system stored procedure sp_helpdb
EXEC sp_helpdb TEST
1) Use system stored procedure sp_helpdb
EXEC sp_helpdb TEST
October 3, 2017
How to Change Compatibility of Database
There are two different ways how we can change the compatibility of database to SQL Server.
1) Using Management Studio
For this method first to go database and right click over it. Now select properties.
2) Using T-SQL Script.
You can execute following script and change the compatibility settings to 120.
USE [master] GO
ALTER DATABASE [TEST] SET COMPATIBILITY_LEVEL = 120
GO
1) Using Management Studio
For this method first to go database and right click over it. Now select properties.
2) Using T-SQL Script.
You can execute following script and change the compatibility settings to 120.
USE [master] GO
ALTER DATABASE [TEST] SET COMPATIBILITY_LEVEL = 120
GO
Subscribe to:
Posts (Atom)