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?