July 30, 2008 at 9:20 am
Hi Friends,
There was a login id/record in a table and it is deleted yesterday or day before yesterday and we dont know who deleted this record and now want to know who and what time it happened.We are not runing trace on this server and in SQL Server Logs under management there is no any entry which tells us all this. Can you tell me please how i can come to know who deleted and what time deleted this record.
I have transaction log which mean i can restore this record but i think transaction log will not tell me WHO did that.
July 30, 2008 at 11:32 am
The only data you have is what's in the transaction log. That should give you what you need. Get a log parser (www.apexsql.com has the one I use), see what it'll tell you.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 30, 2008 at 11:53 am
Thanks Sir.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply