on change 1

[krkX]

Hi there,

Is there a way to monitor changes to a table?

eg If I add or update a record can the system tell me that it has changed ... ?(stored procedures??)

(i am using SQL server 7)

Thanks,

krkX

 

[grega]

You could write Update/Insert/Delete triggers for each table you want to track, and record all changes in some form of auditing table.

Greg.