hello frineds if you need to know that how much space occupied by your each tables which was created by you.
this is the shortest way for any sql server user.
USE yourdatabasename
EXEC sp_MSforeachtable @command1=”EXEC sp_spaceused ‘?’”
Enjoy all guys and girls.
Tags: Find the size of all tables for any database in sql ser
This entry was posted
on Wednesday, October 8th, 2008 at 2:55 am and is filed under Sql Server.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
Author Of Site
Hello ! I am Arjun Jadeja a Software Engineer by Profession. You can contribute and I will distribute your ideas through this site. Thanks and Enjoy Chat With Me
Sponsered Links
RSS
Leave a reply