Post reply

DML Timestamp

  • August 7, 2007 at 7:57 am

    #118048

    Guys,

    Is there any way to get timestamp of the last DML - delete, insert, update operation performed on a table. I tried 'sysobjects' it only holds create date 'crdate'.

    To get around this I have added new columns DATE_TIME_CREATED, which has default value of getdate() each time when new row is inserted or updated, but it does not cover scenario of deleting a row.

    Any suggestions and inputs would help.

    Thanks

  • August 7, 2007 at 9:42 am

    #725212

    Need auditing. You can use a trigger to insert a value in a audit/logging table when some event happens. Can't use a column in the table for deletes; the row gets removed!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply