Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

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,
0
towo2002
Asked:
towo2002
  • 2
1 Solution
 
dduserCommented:
Exec sp_spaceused  <<TableName>>

Regards,

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

Regards,

dduser
0
 
imran_fastCommented:
SPACE USED BY EACH TABLE
============================
exec sp_MsForEachTable "Sp_SpaceUsed '?'"


Regards

Imran
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now