• Absolutely.

    To clarify what Gail said, tempdb should also be checked, but CHECKDB runs very differently on tempdb so it doesn't all get checked. This is because the underlying mechanism CHECKDB uses (database snapshots) aren't possible on tempdb, so CHECKDB has to resort to taking table locks. I would not attemp to check tempdb every day - try weekly.

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005