--// 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
--// 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
© Copyright by Bob Mihada | Template by Blogspot tutorial(slightly modified)
Comments :
Post a Comment