Home Forums Article Discussions Article Discussions by Author Discuss content posted by Steve Bergkamp List recovery model of databases. RE: List recovery model of databases.

  • January 17, 2008 at 11:11 am

    #769349

    Or:

    select [name], DATABASEPROPERTYEX([name],'recovery')

    from sysdatabases

    where name not in ('master','model','tempdb','msdb')