Index , Database size

Hi all
I need to write a script or simple SQL to run periodically
say every day midnight.
In this,
1) I need to check whether any index in the Database has
been corrupted or need to re-create the index.
2) Provides daily occupancy (in percentage) of [Data +
Log ] file.
Can anyone hep me to give me a poiter to web site or SQL
script to aciehve this.
Thanks ina advance
AnandOne possibility is http://www.dbmaint.com/.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Anand" <gurusanand1@.sifymail.com> wrote in message
news:06e601c35af3$6fe0ebb0$a401280a@.phx.gbl...
> Hi all
> I need to write a script or simple SQL to run periodically
> say every day midnight.
> In this,
> 1) I need to check whether any index in the Database has
> been corrupted or need to re-create the index.
> 2) Provides daily occupancy (in percentage) of [Data +
> Log ] file.
> Can anyone hep me to give me a poiter to web site or SQL
> script to aciehve this.
> Thanks ina advance
> Anand