Database off line; How do I detect with a query

[A.M. de Jong]

How do I detect with a query which database is off-line.
And how do I detect with a query the recovery model of a database.

Bye

Arno de Jong

[David Portas]

EXEC sp_helpdb

See "Status=" and "Recovery=" in the Status column.

--
David Portas
------------
Please reply only to the newsgroup
--

[Simon Hayes]

"A.M. de Jong" <ar****@wxs.nl> wrote in message
news:bo**********@reader10.wxs.nl...

How do I detect with a query which database is off-line.
And how do I detect with a query the recovery model of a database.

Bye

Arno de Jong

select databasepropertyex('MyDB', 'Status')
select databasepropertyex('MyDB', 'Recovery')

Simon