Re: Who deleted my records?

From: Jordan (jfritts_at_learn.colostate.edu)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 08:24:03 -0700

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

Relevant Pages

  • Re: Problem altering table and adding a default
    ... SQL Server does not allow that - you can only add nullable ... > After you add a new column in Enterprise Manager, uncheck Allow Nulls, ... the ALTER TABLE statement above will pass to the SQL Server ... > 4) Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: Running profiler on busy 8-cpu Sql Server
    ... with SQL Server. ... Not only does the Profiler GUI's screen need to ... Server & places it on queues that the Profiler GUI picks up. ... / data columns & filters you define in a profiler trace, ...
    (microsoft.public.sqlserver.server)
  • Re: Problem altering table and adding a default
    ... ALTER TABLE dbo.Test_tbl ADD Notnull_col1 charNOT NULL ... SQL Server does not allow that - you can only add nullable columns. ... After you add a new column in Enterprise Manager, uncheck Allow Nulls, bind the uder- ... Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: stress by profiler ?
    ... Are you running the Profiler on the same machine as SQL Server? ... The response time of DB access is also good. ... -- very low Disk Read ...
    (microsoft.public.sqlserver.server)
  • Re: Should I Index?
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > A good place to start is the index tuning wizard. ... Use profiler to do this. ... some suitable indexes based on the workload. ...
    (microsoft.public.sqlserver.server)