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?
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/