Looking for a method on how to get the table spaced used

Dear all,

I'm using SQL Server 2000 and now I'm looking for any method / tools that can retreive the physical space used of every single table.  Please kindly advise.

Regards,
LVL 1
towo2002Asked:
Who is Participating?
 
imran_fastCommented:
SPACE USED BY EACH TABLE
============================
exec sp_MsForEachTable "Sp_SpaceUsed '?'"


Regards

Imran
0
 
dduserCommented:
Exec sp_spaceused  <<TableName>>

Regards,

dduser
0
 
dduserCommented:
This is Procedure available in SQL SERVER, run this via Query Analyzer...

Regards,

dduser
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.