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]

Thanks.

No comments:

Post a Comment

Comments posted on ASP.Net Ajax Tutorials Blog are moderated and will be approved only if they are on-topic and not abusive. Please email me or my team for tech-support or blogging related questions. Avoid including website URLs in your comments - Thanks Author