Technical Article

Recovery Model on all Databases - w/o cursor

,

Recovery Model on all Databases - w/o cursor

select name,DATABASEPROPERTYEX (name, 'Recovery') 
from sysdatabases
where category in ('0', '1','16') 
order by name

Rate

Share

Share

Rate