• In short, no, on SQL 2000 you will not be able to tell if/when/who dropped a table. Your only option is to restore the table from a backup...if such a backup exists.

    On the very off chance you had C2 auditing enabled, or are running a constant trace for auditing pruposes, you may be able to find out. But it's highly unlikely that either is the case.

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!