any stored procedure to report all the databases' information

Hello everyone,

We're going to migrate our SQL 2000 server from one domain to another.  I
need to get a better idea of how our current databases are structured and
utilized.  What I want is a report showing each database's:

name
data size
log size
users
if backed up or not

Before I dive into it in my own way, just wondering if there is any stored
procedure that can help collect the above information?  I'd appreciate any
help.

Thanks,

Bing

sp_helpdb does most what I wanted.

"bing" wrote:

> Hello everyone,
>
> We're going to migrate our SQL 2000 server from one domain to another.  I
> need to get a better idea of how our current databases are structured and
> utilized.  What I want is a report showing each database's:
>
> name
> data size
> log size
> users
> if backed up or not
>
> Before I dive into it in my own way, just wondering if there is any stored
> procedure that can help collect the above information?  I'd appreciate any
> help.
>
> Thanks,
>
> Bing