Wednesday, March 28, 2012

Recovery Model code in SQL 2000

In SQL 2005, sys.databases has a column named recovery_model that stores a code for the type of recovery model used by the database. Where is the recovery_model column in the SQL 2000 master database?

Thanks,

Craig


Code Snippet

select name, Databasepropertyex(name, 'Recovery') recovery from master..sysdatabases

sql

No comments:

Post a Comment