Checking the SQL Server Compability
Method 1
Open the SQL Server Management Studio. Expand the databases tree, right click on database instance and choose Properties. Go to Options page and you will see the compatibility level there.
Method 2
Execute below query.
EXEC sp_helpdb;
Changing the SQL Server Compatibility
Method 1
As per checking on Method 1, you can change the compatibility from the selection.
Method 2
Use below command,
ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 }Note
60 = SQL Server 6.0
65 = SQL Server 6.5
70 = SQL Server 7.0
80 = SQL Server 2000
90 = SQL Server 2005
100 = SQL Server 2008 and SQL Server 2008 R2
110 = SQL Server 2012
