• Here is another one..

    select name,recovery_model_desc as Recovery_mode from sys.databases order by name