Re: Who deleted my records?

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 01/24/05

  • Next message: Riki: "Re: Who deleted my records?" 
    Date: Mon, 24 Jan 2005 09:43:10 -0700

    Just to clarify....profiler can't be used to review past
    activity if you weren't running a trace. I believe Dejan
    meant that you could use the tool to monitor the tables to
    figure out what is going on with the tables and find the
    issue if it occurs again. If you need to check past
    activity, you'd have to use a third party product that will
    analyze your log such as Log Explorer from Lumigent:
    www.lumigent.com

    -Sue

    On Mon, 24 Jan 2005 08:24:03 -0700, "Jordan"
    <jfritts@learn.colostate.edu> wrote:

    >Ok, will do. I've used Profiler in the past to check current activity, but
    >didn't know it could review past activity w/o being enabled.
    >
    >Thanks, Jordan
    >
    >
    >"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote in
    >message news:unSq7ATAFHA.2552@TK2MSFTNGP09.phx.gbl...
    >> > 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: Riki: "Re: Who deleted my records?"

    Relevant Pages

    • Re: Create indexed view
      ... Columnist, SQL Server Professional ... "Dejan Markic" wrote in message ... I'm just interested about the query with which I can ... select id,name from t1 union all ...
      (microsoft.public.sqlserver.programming)
    • Re: Login failure
      ... i got the solution atlast. ... from there connection is being established and sql server ... >hi dejan ...
      (microsoft.public.sqlserver.security)
    • Re: SQL Server DBA Tools
      ... Dejan, thanks for the reply. ... are no cross-server, multi-database documenting/management tools. ... >> I'm very new to the SQL Server DBA world. ... >> would be great if this tool could mine general database ...
      (microsoft.public.sqlserver.tools)
    • Re: Login failure
      ... changing the registry of sql server 7 from 1 to 0 the ... >mode Windows Only). ... Try to connect with sa login. ... >Dejan Sarka, SQL Server MVP ...
      (microsoft.public.sqlserver.security)
    • Re: Windows authentication failed on SQL2000 +NT4
      ... Thanks for your reply Dejan, ... followed the instructions from the SQL Server Book. ... > You have to grant access to SQL Server to Win users and groups. ...
      (microsoft.public.sqlserver.security)