Find the Recovery Model of all databases in MS SQL

 Run the following script to list the Recovery Model setting for all DBs in MSSQL

SELECT Name, DATABASEPROPERTYEX(Name,'RECOVERY') AS [Recovery Model] FROM master.dbo.sysdatabases