Delete Trigger to capture Login, Application, etc

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 10, 2013 at 5:30 pm

  #394153

  I have a situation where a developer is inserting a large number of records into a table.

  They performed the load yesterday but this morning the records are gone.

  This is in the development environment so a lot of people have permissions.

  There is only one job that calls an SSIS package that deletes records from this dimension table but there is a WHERE Clause that restricts what records that get deleted so this package is not the culprit.

  I have DDL Packages where I capture all DML operations.

  I need to create a Trigger where I capture the Login, Datetime, Application that was used to delete the records.

  Does anyone have a sample DML Delete Trigger that i could use as a reference?

  Thank you!

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/