You can use a tool such as profiler but it can be cumbersome or imposable to
find what your after and it has some performance and maintenance down sides
that you have to deal with. You can use triggers but again they have
downsides that you may not want to deal with. There are some 3rd party
tools such as www.redmatrix.com that can help to create the triggers. But
the tool from lumigent will give you the most features in the least amount
of time in a very well thought out interface. While it may seem like a lot
of money it will save you much more than that in time you won't have to
spend dealing with the alternatives.
--
Andrew J. Kelly
SQL Server MVP
> I have stumbled onto that site already today, is there no other way to do
> this than with a third party tool? or is it database triggers all the
way?
> Cheers,
> Andy D
> > The best tool for the job is from www.lumigent.com
> > --
> > Andrew J. Kelly
> > SQL Server MVP
> > > Hi all, wasn't sure where to post this so decided to try here first
of
> > all.
> > > What I am trying to do is to see what changes are being made to
records
> in
> > a
> > > certain database by a program being run on a client that updates data.
> > The
> > > SQL server is version 7.0 and I have been trying to use Profiler to do
> > this
> > > with no joy so far. I dont fancy setting up triggers to track the
> changes
> > > as there is over 100 or so tables in the database.
> > > Can anyone point me in the right direction for doing this sort of
thing?
> > > Thanks in advance,
> > > Andy D
by