List Database Recovery Mode on a server

A handy script to have around for a nice report.

SELECT LEFT(name,50) DatabaseName, CONVERT(VARCHAR(50),DATABASEPROPERTYEX(name, 'recovery')) RecoveryMode  
    FROM sysdatabases 
    WHERE name NOT IN ('model','tempdb') 
    ORDER BY name