Get Record Count for each table in a database.

/**********************************************************
SCRIPT WRITTEN BY  : HARI NARAYAN SHARMA
SCRIPT WRITTEN DATE: 15 AUGUST 2007
PURPOSE   : TO GET REOCRD COUNTS FOR EACH TABLE IN A DB.
**********************************************************/DECLARE @Table TABLE (Table_Name VARCHAR(100), Record_Count INT)
DECLARE @Table_Name VARCHAR(100)
DECLARE CUR CURSOR FOR 
SELECT name FROM SYSOBJECTS WHERE xtype='U'
OPEN CUR
FETCH NEXT FROM CUR INTO @Table_Name
WHILE @@FETCH_STATUS=0
BEGIN
INSERT INTO @Table 
EXEC('SELECT '''+@Table_Name+''',(SELECT COUNT(*) FROM ['+@Table_Name+'])')
FETCH NEXT FROM CUR INTO @Table_Name
END
CLOSE CUR
DEALLOCATE CUR

SELECT * FROM @Table
GO