Viewing post 1 (of 2 total)
Or:
select [name], DATABASEPROPERTYEX([name],'recovery')
from sysdatabases
where name not in ('master','model','tempdb','msdb')
January 17, 2008 at 11:11 am
#769349