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
No comments:
Post a Comment