Use this query to select the recovery model and compatibility level of a DB on a MS SQL 2005 server.

 

select
   name, recovery_model_desc, compatibility_level
from
   sys.databases