Database Utility Script 1---Querying the database for table names that have data and the number of rows of data in the table

CREATE TABLE #Temp
(
Name varchar (30),
Num int
)

DECLARE @Name varchar (30)
DECLARE @Sql varchar (1000)

DECLARE d_cursor cursor FOR
Select name from sysobjects where xtype= ' u '

Open D_cursor

Fetch Next from D_cursor to @Name
While @ @Fetch_Status =0
Begin
Set @Sql =0
Set @Sql = ' SELECT ' + @Name + ', COUNT (*) from ' + @Name + '
--print @sql
INSERT INTO #Temp exec (@sql)

Fetch Next from D_cursor to @Name
End
Close D_cursor
Deallocate d_cursor

SELECT * FROM #Temp

drop table #Temp

Database Utility Script 1---Querying the database for table names that have data and the number of rows of data in the table