The sp_spaceused special SQL procedure displays the number of rows, disk space reserved, disk space used by a table, or indexed view in the current database. Here is a small example of how to use it:
EXEC sys.sp_spaceused @objname = N'DatabaseName.TableName';