How to Find SQL Databases in SIMPLE Recovery Model

Very simple…

SQL 2000

USE master
GO

SELECT catalog_name
FROM information_schema.schemata
WHERE DATABASEPROPERTYEX(catalog_name,'RECOVERY') = 'SIMPLE' ;

SQL 2005-2008

USE master
GO

SELECT name
FROM sys.databases
WHERE recovery_model_desc = 'SIMPLE'