Tuesday, August 07, 2007

What's The Recovery Model?

Quick! Gimme the recovery model for all your databases!


select name, databasepropertyex(name, 'Recovery') from master.sys.databases

Didja beat me? :-)
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)