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@.microsoft.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. You could also use the system stored procedure
"sp_spaceused " to get the space usage. For transaction log usage use DBCC SQLPERF(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
sql