I inherited a database server with SQL Server 2012 Enterprise Edition. All the databases (except for the system databases) are at the 90 compatibility level.
How do I justify updating them to 110 compatibility level?
Let me rephrase my question:
The server is upgraded to SQL 2012 but user databases' compatibility levels were not updated to 110. So tempdb etc system dbs are 110 but user databases are still 90. I would like to update them all to compatibility level 110. I wish it's as simple as ALTER database compatibility level. :) But I need to justify use of resources to thoroughly test the applications out.
Am I right to say that even though the system databases were in compatibility level 110 but the user databases are not reaping the benefit of SQL Server 2012? Which means the databases were not really upgraded?