Add TempDB to integrity check

[PierreLetter]

As part of the system DBs, why not run DBCC CheckDB on TempDB as well?

[olahallengren]

Tempdb is recreated when you restart SQL Server, and does not contain any data. This is the reason, I am not including it in SYSTEM_DATABASES.

If you still prefer to perform checkdb of tempdb, you can do like this:

EXECUTE dbo.DatabaseIntegrityCheck
@Databases = 'SYSTEM_DATABASES,tempdb',
@CheckCommands = 'CHECKDB'