Re: Who deleted my records?
From: Riki (riki_at_nospam.com)
Date: 01/24/05
- Next message: ann: "Tables Views Functions"
- Previous message: Sue Hoegemeier: "Re: Who deleted my records?"
- In reply to: Jordan: "Who deleted my records?"
- Next in thread: Alex: "RE: Who deleted my records?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 24 Jan 2005 16:56:24 +0100
Jordan wrote:
> I have a sql server db linked (via dsn-less ODBC) via Microsoft
> Access. We use one NT authentication, and a single active directory
> group for the access to this database for reading/writing.
>
> In the past week, I have had two tables entirely cleared of data. I
> was wondering how I could find out which user deleted my records?
>
> Thanks, j
Did you put auditing on?
Then read the Event Logs to find out who logged on when.
This will give you at least some information.
-- Riki
- Next message: ann: "Tables Views Functions"
- Previous message: Sue Hoegemeier: "Re: Who deleted my records?"
- In reply to: Jordan: "Who deleted my records?"
- Next in thread: Alex: "RE: Who deleted my records?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
