select databasepropertyex(name,'Recovery'), name
from master.dbo.sysdatabases
where name not in ('master', 'tempdb','northwind','pubs') 
and databasepropertyex(name,'Recovery') <> 'FULL'