Have you fixed your problem? Or did you restore from a good .bak?

DBCC Checkdb with ALL_ERRORMSGS, NO_INFOMSGS, TABLOCK

I had similar problem and I used hint TABLOCK. Please try...

For example, dbcc checkdb (20-30G) or exec a stored proce, it gives out insufficent memory.

Thanks for looking at this!

Thanks! I got it. I will continue getting this error if no action now. I really appreciate your help!!!

Yes. Actually this db is broken already - months ago - I just got this server recently. So I will take care of this later.

Thanks,

Thanks for the reply. Here is extra from error log. Any advice on below error log? Thanks in advance.

CImageHelper::Init () Failed load of symbol file with path = C:\Program...

I feel strange because for other databases seem ok. But for tempdb there is difference. I just gave out one example with big difference from one of our servers. ...

I used standard sp.

exec sp_databases

DATABASE_NAMEDATABASE_SIZEREMARKS

tempdb8704NULL

------------------------------------------

exec sp_helpdb

namedb_sizeownerdbidcreatedstatuscompatibility_level

tempdb 15.50 MBsa2Sep 16 2011Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=655, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics100

---------------------------------

exec sp_spaceused (use tempdb)

database_namedatabase_sizeunallocated space

tempdb15.50 MB12.67 MB

reserveddataindex_sizeunused

1616 KB728...

Thanks for the replies and I will continue to research the tempdb problem.