?
Solved

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

Posted on 2006-11-19
3
Medium Priority
?
212 Views
Last Modified: 2006-11-23
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
Comment
Question by:towo2002
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 9

Expert Comment

by:dduser
ID: 17977337
Exec sp_spaceused  <<TableName>>

Regards,

dduser
0
 
LVL 9

Expert Comment

by:dduser
ID: 17977340
This is Procedure available in SQL SERVER, run this via Query Analyzer...

Regards,

dduser
0
 
LVL 28

Accepted Solution

by:
imran_fast earned 1000 total points
ID: 17977405
SPACE USED BY EACH TABLE
============================
exec sp_MsForEachTable "Sp_SpaceUsed '?'"


Regards

Imran
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question