Old Compatibility Level
sp_Blitz Result: Old Compatibility Level
Each SQL Server database has a setting called compatibility level that kinda-sorta influences how T-SQL commands are interpreted. There’s a lot of misconceptions around what this does – some people think setting a database at an old compatibility level will let an out-of-date application work just fine with a brand spankin’ new SQL Server. That’s not usually the case, though.
This part of our SQL Server sp_Blitz script checks the compatibility_level field for each database in sys.databases and compares it to the compatibility_level of the model database.
To Fix the Problem
Check out the Books Online explanation of how to change compatibility levels of a database.