• JP,

    try running sp_helpdb without passing any parameters, the recovery model is listed in the 'status' column.

    lloyd