Count rows in all tables over time SQL 2K only

/*-----------------------------------------------------------------------------------------------

This script tracks the rows in a database over time.
The base table used is #TempRowCount, which has new records added everytime the script is run.
A dynamic query based on that table will display all tables that have had their row count changed since the last
time the script was run.

*/-----------------------------------------------------------------------------------------------
if object_ID('tempdb..#TempRowCount') is null
	begin
		create table #TempRowCount (TableName varchar(255), RowCnt int, BatchID int, Instance datetime)
	end


declare @BatchID int,
		@stQuery varchar(8000)


declare @TempRowCount Table (TableName varchar(255), RowCnt int, BatchID int, Instance datetime)


/*--------------------------------------------

Update Base Table with rowcount figures


*/--------------------------------------------
select top 1 
	@BatchID = BatchID + 1 
from #TempRowCount (nolock) 
order by BatchID desc

IF @BatchID is null set	@BatchID = 1


--Using temp table to store date before inserting into permanent table (query was hanging due to...feedback?)
Insert	@TempRowCount
Select 	so.name, convert(int, sc.rowcnt) as RowsInTable, @BatchID, getdate()
From	sysobjects so (nolock)
JOIN	sysindexes sc (nolock) on so.id = sc.id
WHERE 	sc.indid < 2 and so.Name <> '#TempRowCount'


--Update permanent table 
Insert	#TempRowCount
Select * from @TempRowCount



/*--------------------------------------------

Create Query to turn batches into columns (the name of the column is the time it ran)

*/--------------------------------------------


declare @Query Table (BatchId int, instance datetime)
Insert 	@Query
Select	distinct batchid, instance
From	#TempRowCount (nolock)


--begin Select clause
select	@stQuery = 'Select t.TableName, t.RowCnt ',
		@BatchID = 0


--Finish Select clause
While 1 = 1
	Begin

		select	@BatchID = BatchID,
				@stQuery = @stQuery + ', (t' + cast(BatchID as varchar) + '.RowCnt - t.RowCnt) [' + convert(varchar, instance, 108) + ']'
		From	@Query
		Where	BatchID > @BatchID
		order by batchid 
	
		If @@rowcount = 0 Break


	end

--begin from clause
select	@stQuery = @stQuery + ' From #TempRowCount t ',
		@BatchID = 0



--Finish from clause
While 1 = 1
	Begin

		select	@BatchID = BatchID,
				@stQuery = @stQuery + ' LEFT JOIN #TempRowCount ' + 't' + cast(BatchID as varchar) + 
							' (nolock) on (t.TableName = t' + cast(BatchID as varchar) + '.TableName and t' + cast(BatchID as varchar) + '.Batchid = ' + cast(BatchID as varchar) + ')'
		From	@Query
		Where	BatchID > @BatchID
		order by batchid 
	
		If @@rowcount = 0 Break
		
	end


--Add where clause
set @stQuery = @stQuery + ' Where t.BatchID = 1 and (t' + cast(@BatchID as varchar) + '.RowCnt - t.RowCnt) <> 0'


exec (@stQuery)