Set compatibility to SQL 2005


--// Note To Self
--// Set compatibility to SQL 2005
SELECT
    ' ALTER DATABASE [' + name + '] SET RECOVERY SIMPLE
  exec sp_dbcmptlevel ' + name + ', 90'
FROM
    sys.databases
WHERE
    compatibility_level < 90

Comments :

0 comments to “Set compatibility to SQL 2005”