Re: Transaction Tracing

• Previous message: Jasper Smith: "Re: patching"
• In reply to: Viji Pinarayi: "Transaction Tracing"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Wed, 09 Mar 2005 18:59:29 -0700

You can use Profile to set up traces of activity but this is
something you configure before hand. If you don't have any
mechanisms in place before, there is nothing built into SQL
Server to track what changes you may have made.
There are some third party tools that will read transactions
in SQL Server log files so that is an option. Check Log
Explorer from Lumigent: www.lumigent.com

-Sue

On Wed, 9 Mar 2005 09:17:03 -0800, "Viji Pinarayi" <Viji
Pinarayi@discussions.microsoft.com> wrote:

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

• Previous message: Jasper Smith: "Re: patching"
• In reply to: Viji Pinarayi: "Transaction Tracing"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]