Re: Who deleted my records?

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

  • Next message: Shane: "Linking to MySQL" 
    Date: Sun, 23 Jan 2005 13:34:54 -0700

    Using profiler as Dejan suggested is how you'd want to track
    this. Just thought I'd mention, one thing to look for if
    it's not users doing this would be if the tables are
    populated by DTS packages. May not be your case but I've
    seen others look and look for whatever was causing similar
    issues and it turned out to be their packages.

    -Sue

    On Fri, 21 Jan 2005 15:04:19 -0700, "Jordan"
    <jfritts@learn.colostate.edu> 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
    >

  • Next message: Shane: "Linking to MySQL"

    Relevant Pages

    • Re: Need help with DTS Package Maintenance
      ... You can create DTS packages in VB, ... > source Interbase Database and I make a SQL Server connection to the target ...
      (microsoft.public.sqlserver.dts)
    • Re: Standard Method for Importing/Exporting to DB
      ... the database name, server name, and filename+fullpath. ... and also exporting to CSV files. ... everything from DTS packages to Crystal Reports are used. ...
      (microsoft.public.dotnet.languages.vb)
    • Re: How do I distribute DTS Packages with my Application Database?
      ... BTW, is there any way to store a DTS package in a specific *database*, as ... And if not possible with SQL Server ... > Number of ways but undoubtedly the easiest is as a Structured Storage file ... >> distribute my DTS Packages? ...
      (microsoft.public.sqlserver.dts)
    • Re: SQL Server 2005 DTS problem: "Error 21776: General Error"
      ... restoring on 2005 from the 2000 backup files has worked flawlessly for this ... stuck with the DTS packages. ... once we renamed the server we had problems. ... it's not related to the number of objects in the database). ...
      (comp.databases.ms-sqlserver)
    • Re: restore DTS from a backup
      ... What I would do is to install a temporary SQL Server instance and restore ... the msdb database to this instance. ... Since the DTS packages are saved in this ...
      (microsoft.public.sqlserver.setup)