Posts Tagged ‘Find the size of all tables for any database in sql ser’

8
Oct

Find the size of all tables for any database in sql server 2005

   Posted by: admin   in Sql Server

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.

No Comments
Back to top