|
Home > Archive > MS SQL Server > February 2006 > any stored procedure to report all the databases' information
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
|
|
|
|
|