SQL Server : Retrieving Database and Table Sizes

Created 03 August 2004 00:00

Log file sizes

select size as 'pages', size*8000 as 'size', name from sysfiles

For the whole database

sp_spaceused @updateusage = 'TRUE'

For a specific table

sp_spaceused @objname = '<table_name>'