Thank you Richard for the script. Newbie to SQL Server and am using 2008 R2 and am getting the following error:

Cannot enable compression for object 'DatabaseGrowth'. Only SQL Server Enterprise Edition supports compression.

Would apprecaite any help.

Thanks