Delete Trigger

• hassanmir

  Mr or Mrs. 500

  Points: 568

  More actions

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737892

  More actions

  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