• Hugo Kornelis (8/20/2010)You can actually run DBCC CHECKALLOC and DBCC CHECKCATALOG on tempdb. You will not get an error, but on the other hand, nothing will actually be done.

    Which version is that on? With 2008 I get

    The check statement was aborted. DBCC CHECKALLOC cannot be run on TEMPDB.

    The check statement was aborted. DBCC CHECKCATALOG cannot be run on TEMPDB.