Setting SQL Server Database Compatibility level for all databases
Setting the database compatibility level for a couple of SQL Server databases can be a simple task. But what if you had 30 or 40 databases? For those of you with a lot of databases, he is a simple step by step process to update the compatibility level to version 11 (SQL Server 2012).