Transaction Logs - Viewing
From: Bryan Clauss (BryanHood1@yahoo.com)
From: "Bryan Clauss" <BryanHood1@yahoo.com> Date: Thu, 20 Mar 2003 06:59:54 -0800
We are using MS-SQL 2K SP3, using the Full Recovery
option, and we back up the transaction logs are backed up
every 2 hours.
An unknown user performed a "Delete Transaction" through
an application in one of our tables for a specific record.
Is there a way to look at the log to see who the specific
I realize that, at most, the log would only show the user
who was logged onto the network, but that may be enough.
I know the approximate time (a 6 minute window) and the
day that the Delete Transaction was issued.