SP_SPACEUSED - Displaying Space Information

1. Displaying disk space information about a table

----start-----
USE AdventureWorks;
GO
EXEC sp_spaceused 'PRODUCTION.Product';
GO
----end-----

3

 

2. Displaying updated space information about a database

USE SeA_Samples
GO
EXEC sp_spaceused @updateusage = 'TRUE';
GO
 

 

 

Source:
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/c6253b48-29f5-4371-bfcd-3ef404060621.htm