Thank you! I hope it helps you out. 🙂

Finally, the answer. There is indeed a bug when using the GUI:

http://sqlblogcasts.com/blogs/sqldbatips/archive/2007/03/07/another-maintenance-plan-bug-database-integrity-checks.aspx

Quote:

Another SP2 Maintenance Plan bug - Database Integrity Checks

** Update: A hotfix is now available to address this issue...

It was primarily developed for SQL Server 2005.

Very nice! Thanks for all of the helpful tips and tricks. 🙂

I've run extensive profiler traces and there is no additional / unusual activity going on. In additional to this, the SSIS package always runs in 30 seconds while the SSMS...

I actually just decided to isolate the largest single database and create a plan for it to do quick compares. So, for 1 DB I am only using the "Check...

I know that in SQL 2000 you used to be able to do it, but I believe it was only possible one SPID at a time, and not part of...

I am actually working on "holiday logic" for the next version. 🙂

NP. 🙂 LOVE the quote. 🙂

I'll put it on the to do list. 🙂 Great idea. As for the first day of the week, it should change automatically to whatever your SQL Server instance settings...

Thanks! Dates can be a REAL pain to work with sometimes, so I figured that this could help a lot of people.

It was developed on SQL Server 2005, though it should work on 2008. Have you tried running it on a different database? Also, sometimes when you copy scripts from SQLServerCentral.com...

My pleasure. Hope it helps!

Very cool alternative. Thanks for sharing! 🙂