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...

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!