SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by alanw / Quickly Reveal DB Recovery Model on all Databases. / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 10:08:27 GMT20RE: Quickly Reveal DB Recovery Model on all Databases.http://www.sqlservercentral.com/Forums/Topic404904-799-1.aspxHi,Simpler scirpt :select name, databasepropertyex(name, 'Recovery') as RecoveryModel from master.dbo.sysdatabases order by nameFri, 09 Mar 2012 05:26:35 GMTchetanr.jainQuickly Reveal DB Recovery Model on all Databases.http://www.sqlservercentral.com/Forums/Topic404904-799-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Miscellaneous/30715/">Quickly Reveal DB Recovery Model on all Databases.</A>[/B]Mon, 01 Oct 2007 03:02:38 GMTalanw