Database Size (Free,Used)

In SQL Server Enterprise Manager taskpad will display database size free and
used space.

What tables within SQL Server is this information stored?

Is there another way to obtain database size free and used space?

Thanks,

See sp_spaceused in SQL Server Books Online. In master databse, you could
run the following to see what tables this procedure accesses:

sp_helptext sp_spaceused
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Joe K." <Joe K.@discussions.microsoft.com> wrote in message
news:805D5942-D569-4083-99B4- E537F845D880@microso
ft.com...

In SQL Server Enterprise Manager taskpad will display database size free and
used space.

What tables within SQL Server is this information stored?

Is there another way to obtain database size free and used space?

Thanks,

Hi Joe,

Sysindexes system table in each database stores all the space information. Y
ou could also use the system stored procedure
"sp_spaceused " to get the space usage. For transaction log usage use DBCC S
QLPERF(LOGSPACE)

Thanks
Hari
SQL Server MVP


 ____________________
________________
Joe K.  Wrote:


In SQL Server Enterprise Manager taskpad will display database size free and
used space.

What tables within SQL Server is this information stored?

Is there another way to obtain database size free and used space?

Thanks,







Sent via SreeSharp NewsReader http://www.SreeSharp.com