Got it... thank you!

Is it possible to pass the output value to the Email Task body? If so, how?

Thank you guys..

I got you... Thank you!

When do you do reorganize index and stat update?

Great Thank you!

Thanks Steve for the info...

Why is it not recommended? What would be the issue?

I got you... thank you!

This is for Reporting...

Thank you Craig that worked.

I looked it up online before posting, but I was not able to find the format I was looking for.

Thank you!... that was what I was looking for.

Check out these links

http://technet.microsoft.com/en-us/library/aa964127%28SQL.90%29.aspx

http://www.rpttordl.com/

I had another question on this... is backing up the log file (overwrite mode) every two hours and backing up the DB once a day (at night) a good idea,...

Thank you that is helpful

Okay thank you both... What is the difference between shrinking and emptying?

Also, how often do you recommend the backup to be scheduled?

Alex thanks. The DB is backed up everyday at night. So if I understand you correctly does that mean once the DB is backed up, the system is smart...