• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • 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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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