Link to home
Start Free TrialLog in
Avatar of Gabriel_Espinoza
Gabriel_EspinozaFlag for Chile

asked on

Find when a DELETE statement executed

Hello!

I have a Table where no registry should be deleted. Someone deleted a registry.

Is it possible to know when that happened? some sort of log where that kind of information would be stored?

I'm using SQL Server 2008
The engine is mounted in a Windows 2008 R2 Server

in advance many thanks.
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Gabriel_Espinoza

ASKER

ohw :(

thank you for answering.

I know the security here is not the best, I suppose to trust in developers, I only have 6 ppl, I will find who did this.
TT_TT