Re: Tracking Data Changes
From: Panks (agarwalp_at_eeism.com)
Date: 07/19/04
- Next message: Beeeeeeeeeeeeves: "Re: DTS permissions?"
- Previous message: Anith Sen: "Re: query help"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 19 Jul 2004 18:26:03 +0530
Whats the solution
"a" <a@a.a> wrote in message news:#jRDhPVXEHA.1152@TK2MSFTNGP09.phx.gbl...
> I need to log all changes in all tables and in all fields. This includes
> inserts, deletes, and updates. Using SQL Profiler doesn't really do what
I
> need because each time the server is rebooted somebody needs to get
Profiler
> running again. Also, Profiler seems to stomp on previous log files or
> tables which is undesirable. I'm not so sure that Profiler will do a very
> good job at logging the changes in such a way as to allow later queries of
> the log table to inspect the changes and know exactly what changed, when,
> and by who.
>
> I thought about using triggers and the inserted/deleted tables to move the
> changed data to a log table, but I have several hundred tables, some
tables
> with more than 500 fields, so it isn't practical or efficient to write
> triggers that have hard-coded field names in them, especially since over
> time the tables are likely to change and I don't want anyone to deal with
> broken triggers.
>
> The be-all end-all solution I am hoping for is a stored procedure that
> doesn't need to know the field names yet gives me a way to associate data
> with the field names, is quick and consumes very little processor time,
and
> logs data to a table that can be queried in such a way that will
immediately
> show what data changed with each update, what data was inserted, and what
> data was deleted, at what time, and by what NT user.
>
> I have looked at bcp and dbcc but neither looks like a good solution for
me.
> I have seen some third-party software packages out there that cost money,
> and read the transaction tables. But the problem is it seems that those
are
> just showing me the sql statements and not really giving me a way to query
> the changes into a report. Also, they cost money and need external
support.
>
> Thanks in advance,
>
> z
>
>
>
>
>
>
- Next message: Beeeeeeeeeeeeves: "Re: DTS permissions?"
- Previous message: Anith Sen: "Re: query help"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
