MSQLDBA (12/12/2013)

---

Hi Buddies,

I am facing the same problem even my database Auto_close option is False. When the application team running package, database going on suspect mode. rest of the time its working fine. I am also not getting any error message in Evnt log and SQL server error log for the same. I put database on emergency mode and run dbcc checkdb i found one table corruption in the database, after putting database on online i didn't get any corruption in the database, result is showing no error.

Could you please help me to fix this issue?

Thanks in advance.

M.I