Home Forums SQL Server 2005 SQL Server 2005 General Discussion Find who/process that deleted records RE: Find who/process that deleted records
Pam Brisjar
SSChampion
Points: 12094
More actions
January 17, 2008 at 6:36 pm
#769508
Retroactively, probably not. There's a very slim chance that you might possibly find a shred of evidence in the transaction logs.
Proactively:
set up a Profiler trace or an On Delete trigger (best if there's a specific table in question).