Unanswered: Possible To Tell Who Deleted Records In My SQL Table?
Is there a way to check who has deleted records from my SQL tables? I asked because I notice records keep disappearing from my tables recently for no reason. The DB is only accessible by a few IT staff. Business users have no direct access to it so they can't do any harm and there is no application that update these record missing tables.
I don't need to know the exact records that have been removed. I need info on who has made a deletion activity on which table, date and time is good enough.
Thank you for your advises. If this person is using query analyzer to delete the records from a remote connection, will the trace be able to detect it? I have discovered 35 records missing from my table this morning.