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.

Return to sp_Blitz or Ask Us Questions