September 27, 2007 at 2:41 pm
Comments posted to this topic are about the item List recovery model of databases.
January 17, 2008 at 11:11 am
select [name], DATABASEPROPERTYEX([name],'recovery')
where name not in ('master','model','tempdb','msdb')
January 17, 2008 at 11:25 am
Much cleaner and avoids loops and unnecessary temporary tables.
Hall of Fame
April 29, 2008 at 10:46 am
Here is another one..
select name,recovery_model_desc as Recovery_mode from sys.databases order by name
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply