Checking the recovery model

-- SQL Server 2000

SELECT name ,
DATABASEPROPERTYEX(name, 'Recovery')
FROM sysdatabases

-- SQL Server 2005/2008

SELECT name ,
recovery_model_desc
FROM sys.databases