...Here is the 2000 Version..of the code....

--PART 1

If exists (Select name from sysobjects where name = 'DBGrowthRate' and Type = 'U')

Drop Table dbo.DBGrowthRate

Create Table dbo.DBGrowthRate (DBGrowthID int identity(1,1),...

All...

I have corrected the code..As it has flaws dealing with date comparison...And hence you are not getting the GROWTH amount on weekly runs...

Here is the UPDATED code (works for 2005,...

All SQL Folks...

The original script has MAJOR error....

--In PART2 --- where it runs to update the growth table...it tries to convert the DATE to CHAR...and then compares with GetDATE() --...