rows from a table deleted not sure who and/or when

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 1

You would need to pick up a third party log explorer tool. There's no way to do this with native SQL Server tools.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

ravikanth. Hall of Fame Points: 3472 More actions · Answer 2

If this is Sql Server 2005, there will be default trace running.You might find more information there.

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 3

The default trace doesn't capture DML. I learned that one the hard way.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Todd Engen SSCrazy Eights Points: 9869 More actions · Answer 4

You might be able to find out when it happened using the fn_dblog function.

SELECT [transaction id],[begin time],[spid],[allocunitname],[operation]

FROM fn_dblog(NULL,NULL)

--WHERE operation='LOP_DELETE_ROWS'

--WHERE [transaction id]='0000:00027a0a'