Re: Who deleted my records?

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 01/23/05

  • Next message: DBADave: "BuiltinAdministrator's not SysAdmin yet appear to have DBO on all" 
    Date: Sun, 23 Jan 2005 10:45:07 +0100

    > 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?

    Check the Profiler, the tool that comes with SQL Server. It can catch all of
    the activity on SQL Server. It is described in SQL Books OnLine. 

    -- 
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
  • Next message: DBADave: "BuiltinAdministrator's not SysAdmin yet appear to have DBO on all"

    Relevant Pages