While it's not 100% required, your life is generally better if your databases are set to the maximum database compatibility level that your server supports. But it's a bit of a pain to actually make that change. So in our free SDU Tools for developers and DBAs, we have a procedure that does just that. It's called SetDatabaseCompabilityForAllDatabasesToMaximum.
It's a stored procedure and takes no parameters at all.
It checks all the user databases and sets them to the maximum level allowed by the server that they are attached to. It is applicable to SQL Server only. (This procedure doesn't exist in the Azure SQL Database version of the tools).
You can use our tools as a set or as a great example of how to write functions and procedures like these.
Find out more
You can see it in action in the main image above, and in the video here:
Access to SDU Tools is one of the benefits of being an SDU Insider, along with access to our other free tools and eBooks. Please just visit here for more info: