Mike Tutor (2/22/2010)

---

Thanks for the great script. I created a table with a capture date and put your script (with some minor modifications) into a weekly job. This way I can keep a history of database growth and use it for charting expected growth etc.

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DBStats]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[DBStats]

GO

CREATE TABLE [dbo].[DBStats] (

...

GO