Recovery Model

How can you tell the recovery model of a database using SQL Syntax?
DonSELECT
name,
convert(sysname,DatabasePropertyEx(name,
'Recovery'))
FROM
master.dbo.sysdatabases|||Hi Don
Use the DatabasePropertyEx function, with the Recovery property
SELECT DatabasePropertyEx('<your_database_name>','Recovery')
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Don" <dons100@.ameritech.net> wrote in message
news:64XBf.14331$_S7.1907@.newssvr14.news.prodigy.com...
> How can you tell the recovery model of a database using SQL Syntax?
> Don
>
>