SQL: Quick SQL 2008 upgrade tip

kdevine on January 8th, 2010

If you are re-attaching databases after a SQL 2008 upgrade, here is a quick n dirty T-SQL command to upgrade to the the correct compatibility level, just run, copy the results and run those: select ‘ALTER DATABASE [' + [name] + ‘] SET COMPATIBILITY_LEVEL = 100′ from master.dbo.sysdatabases