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