"Russell Mangel" <russell@tymer.net> wrote in message
news:u$Kvi5iPEHA.3348@TK2MSFTNGP09.phx.gbl...
>
> My Question:
> What is the best way to monitor/collect Updates/Inserts to a table in SQL
> Server 7.0?
>
> We have a VB6 DB application that uses SQL 7.0, and I need to figure out
> what it does to the database.
> I would like to see the actual data and Sql query that updated a row(by
> Column if possible).
> I would like to see the actual data and Sql Query that inserted the
> row(s).
>
> Is there an advanced logging I can configure in Registry, so SQL would
> write
> all queries to file or table?
> I am aware of using a Trigger for this, but I really just need this
> information for discovery/testing purposes.
>
> In other words:
> We have a Legacy VB.x Application which uses SQL 7.0. It was written 9
> years
> ago, and is poorly designed, the source code is very bad spagetti code!
> Almost unreadable.
> So looking at the source code to figure out what the appication does it
> quite difficult, it will be easier to reproduce in modern language.
> Example:
> When a new customer is added to the system. I want to know what tables &
> columns were Updated/Inserted to create the new customer.
>
> Thanks
> Russell Mangel
> Las Vegas, NV
>
>
>