Post reply

Delete Trigger

  • February 7, 2002 at 9:39 am

    #78034

    How would i implement a trigger that would log any row-deleted event in a table. I would like to know userid, datetime, application, workstation.

    Thanks for your help

  • February 7, 2002 at 10:03 am

    #423406

    You could implement a delete trigger to write this information to an audit table. However, keep in mind that the hostname is dependent on the client app to send it. If each user logs into the server with their own login, then you can get this from system functions (suser_name(), user_name(), etc.)

    Or you could get a copy of Lumigent's Log Explorer.

    Steve Jones

    steve@dkranch.net

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

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