Just a quick SQL script to get the rowcount and size data of every table in the current database:

CREATE TABLE #sizeof (
 name varchar (70),
 [rows] int,
 reserved varchar(20),
 data varchar(20),
 index_size varchar(20),
 unused varchar(20),
)

DELCARE @name varchar(70)
DECLARE cur CURSOR FOR select name from sys.tables
OPEN cur
FETCH NEXT FROM cur INTO @name
WHILE @@FETCH_STATUS=0
 BEGIN
 INSERT #sizeof EXEC sp_spaceused @name
 END
CLOSE cur
DEALLOCATE cur
SELECT * from #sizeof
DROP TABLE #sizeof

Comments

comments powered by Disqus