its very simple , just need to call this following sp with table name as argument.
exec sp_spaceused 'TableName' and it will return following fields.
name rows reserved data index_size unused
TableName 38701 206912 KB 188088 KB 248 KB 18576 KB
No comments:
Post a Comment