Results 1 to 7 of 7

Thread: Who has deleted records

  1. #1
    Join Date
    Oct 2007
    Posts
    22

    Who has deleted records

    Dear Sir,
    how can i find out as who has deleted particular records from a table.
    i am using SQL2000 SP4
    pls. explain a little bit in detail
    regards

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    You need third party sql auditing tools or run profiler trace all the time.

  3. #3
    Join Date
    Oct 2007
    Posts
    22

    Thanks

    Thanks rmiao...
    can you name me any better third party tool?

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Check Lumigent's Audit DB and Log Explorer.

  5. #5
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can't use it after the fact. Log explorer may show you that data got deleted but will not show where the connection came from.

  6. #6
    Join Date
    Sep 2002
    Posts
    5,938
    It tells db user and windows id.

  7. #7
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    I don't think user information is in transaction log, so if you are running lumigent on old transaction log files when lumigent was not capturing login information you don't see that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •