We need to see what are the tables having huge volume and needs to a backup and clean the existing data.
Since there are veryu huge no of tables we need to get the record counts for all the tables with a single query .
Can any one of them created any stored proc or query to get this ouptu if so please help me also to close this actviity .
Out put table looks like
TName !!Current Table size!! Prev_table_size !!current Record count !!prev record count !!column count !! Index count1!!current Index size!!Prev Index size!!
Please suggest and help at the earliest
Thanks In advance