Transaction Tracing

From: Viji Pinarayi (Pinarayi_at_discussions.microsoft.com)
Date: 03/09/05 

Date: Wed, 9 Mar 2005 09:17:03 -0800

I have a trivial, but important problem. I am managing a software developed
in VB with SQL server 7 as back end. For debugging purpose, I had made an
entry in a particular filed in a table through SQL Enterprise Manager. The
problem is that now I don't remember the change which I had made in the
record. I would like to know whether I can trace the activity, and if
possible, the date & time on which the entry was made. I know the primary key
field value for the record, but can't get what change was made or at what
time. If I can get the time, it is enough for me, because I can then know
what entry i had made.

So, my qustion is whether it is possible to trace the timestamp of an entry
made in a recod through Enterprise Manager, given the table name, promary key
value name of the field in which edut was done.
 
If anyone has a solid answer for my problem, your help will be of immense
value to me and my organization. Please help...!

Relevant Pages
Quantcast