Friday, May 15, 2009

How to find out space used by Tables and it's Indexes.

In sql server we can find out how much space used by table in databse.
this is possible using stored procedure called sp_spaceused.

this Build int SP take table name as argument and Retrns Columns relating space used by sql table. below is script to find out space usedby Table [EC_cart].

sp_spaceused [EC_cart]