125. SQL Server Script to find and change Compatibility Level of Database

Performance Improvement in SQL, SQL Downloads, SQL SERVER, Sql Server Scripts
  
-- 125. SQL Server Script to find and change Compatibility Level of Database
 
SELECT compatibility_level
FROM sys.databases WHERE name = 'YourDatabaseName';