tweaked your code little to include size in MB and also for all schemas.

Declare @v_TableName Varchar(100)

Declare @v_Table Table (Table_Name Varchar(100))

Declare @v_TableSize Table (

Table_Name Varchar(100),

rows BigInt,

Reserved Varchar(50),

ActualDataSize Varchar(50),

IndexSize Varchar(50),

Unused Varchar(50)

)

Insert Into...

You stand here.

I am one among the poor souls.

Eagerly expecting your next articles.

Regards

Kannan

I am new to the software development. This article impressed me very well. Will try to become a good programmer...

Thank you very much for your valuable thoughts...

Good wishes to you