You might what to create insert, update, delete triggers on each table. Or

within the script each time an update, delete, or insert is done, register

the activity to your log table.





----- Original Message -----

From: "Petr Novotny" <pn@b...>

To: "ASP Databases" <asp_databases@p...>

Sent: Friday, March 08, 2002 2:39 AM

Subject: [asp_databases] Logging problem





> Hi guys,

>

> I have created an application in ASP and I store the data in SQL 7. I was

> asked to create the table that would

> store the information about what each user has done during his session,

> whether he has inserted, deleted, etc.. record from the

> database.

>

> I have no clue where to start.

>

> Can you help me?

>

> Thanks

>

> Petr

>

>




$subst('Email.Unsub').

>

Hi guys,



I have created an application in ASP and I store the data in SQL 7. I was

asked to create the table that would

store the information about what each user has done during his session,

whether he has inserted, deleted, etc.. record from the

database.



I have no clue where to start.



Can you help me?



Thanks



Petr