• 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

    ________________________________________
    M.I.
    [font="Times New Roman"]

    Learning is a path with no destination...
    [/font]