• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 791
  • Last Modified:

recovery_model_desc in SQL 2000

sys.databases has recovery_model_desc. where is that column in SQL 2000? I could not see it in sysdatabases.

thanks
0
anushahanna
Asked:
anushahanna
  • 3
  • 2
3 Solutions
 
chapmandewCommented:
Its in the status column, me thinks.
0
 
chapmandewCommented:
select name, databasepropertyex(name, 'Recovery') as RecoveryModel from master.dbo.sysdatabases order by name
0
 
anushahannaAuthor Commented:
that's it.

is there a reason there is not documentation (that i could find) on sysdatabases.status as you thought so.
0
 
chapmandewCommented:
its a bit, so it has to be parsed that way.  

http://msdn.microsoft.com/en-us/library/aa260406%28SQL.80%29.aspx
0
 
anushahannaAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now