how to get online/offline status

Hi,

i try get information about the online or offline status of a database
within ms-sql srv 2000.

I can look it up within server manager, but I'm looking for a way to get
this information from the command line or a select statement.

Is there a command or a sql statement that tells me the status of a
database ? There's some information in master.dbo.sysdatabases, but it
looks very cryptic.

Any help appreciated, thanks,
stefan"Stefan Behrens" <stefan.news@.gmx.net> wrote in message
news:Xns94DB71E9836ADstefannewsgmxnet@.195.20.224.1 16...
> Hi,
> i try get information about the online or offline status of a database
> within ms-sql srv 2000.
> I can look it up within server manager, but I'm looking for a way to get
> this information from the command line or a select statement.
> Is there a command or a sql statement that tells me the status of a
> database ? There's some information in master.dbo.sysdatabases, but it
> looks very cryptic.
> Any help appreciated, thanks,
> stefan

select databasepropertyex('master', 'status')

Simon

how to get off?

i guess that i hav been tracked down when i am online.How
to get off from their harasses?First you need to get in touch with your old friend who happens to work for
either the CIA or FBI (or both)... But it turns out that he's also being
paid off by the syndicate, so you'll end up fleeing to Mexico in a rented
car. But they'll track you down there, and there will be a big showdown,
and you'll kill the boss right before he's about to kill you! It will all
be very exciting.
By the way, this is a SQL Server newsgroup...
"jim" <anonymous@.discussions.microsoft.com> wrote in message
news:1b05d01c41fa7$759f7340$a501280a@.phx
.gbl...
> i guess that i hav been tracked down when i am online.How
> to get off from their harasses?