Awesome. Thanks for they quick reply!:-D

is this still possible with sql server 2005/2008 with the new DMV's?

One more question, how did you extract the sql maintenance plan? When I click the show TSQL command I just see a message that states "generating tsql script, please wait"

Kevin,

Do you do this in your maintenance plan or are you running a job outside of your maintenance plan? This sounds like the best option and I would like...

Excellent article.

What do you recommend when it comes to maintainence tasks such as a regularly schedule reorganization on tables?

Whenever the maintenance task runs the tlogs fill very fast...

Very good info Gail. This does save a bit on time when compared to reading 181 pages of red gates free e book. Thanks.

downloading now. I will be sure to read through this. Thanks.

Thanks Paul. So do you think I should be concerned about any data corruption?

I'm going to run a test backup before I leave for the day to see what...

This is an awesome thread. Thank you everyone for your input. I got to put these suggestions to valuable use just recently with one of our software developers standing over...

All,

Thank you for your suggestions on how to execute such a basic yet crucial command.

I am testing this scenario now and have come up with a few different...