per quanto riguarda il valore totale delle righe ce l ho fatta
ho fatto cosi

pippo=0


Do while not rs.eof
if rs("table_type") = "TABLE" then


response.write "<tr><td>" & rs("table_name") & "</td>"

' calcolo spazio occupato
set rsC = conn.Execute("EXEC sp_spaceused " & rs("table_name"))



response.write "<td>" & rsC("data") & "</td>"
response.write "<td>" & rsC("rows") & "</td></tr>"


pippo=pippo+rsC("rows")

rsC.Close
set rsC = Nothing


end if
rs.movenext
loop
response.Write(pippo)