Getting Database Stats

[Derrick King]

COuld someone tell me if its possible to get hold of stats about all
Databases on a SQL Server.

The sort of things I would like are

Name of DB
Location of DB
Size of DB
Location of Logfile
Size of DB
Owner
Users Authorised to access the DB

Is there something that can do this

Thanks

Derrick

[Simon Hayes]

"Derrick King" <de**********@bradford.gov.uk> wrote in message
news:c1**********@newsreaderm1.core.theplanet.net. ..

COuld someone tell me if its possible to get hold of stats about all
Databases on a SQL Server.

The sort of things I would like are

Name of DB
Location of DB
Size of DB
Location of Logfile
Size of DB
Owner
Users Authorised to access the DB

Is there something that can do this

Thanks

Derrick

There are a variety of system stored procedures to get the information, but
if you want to generate reports or overviews, it would probably be easier to
use a client script with SQLDMO to get the information. SQLDMO is a COM
interface used to manage SQL Server installations, so you can access it from
VBScript, Perl, etc. See Books Online for more details.

Simon

[Manoj Rajshekar]

You could use
sp_helpdb [ [ @dbname= ] 'name' ]

to get the details what you are looking for. If you skip the parameter
@dbname you would get info for all the databases (lesser columns).

Regards,
-Manoj Rajshekar