Transaction Logs - Viewing

From: Bryan Clauss (BryanHood1@yahoo.com)
Date: 03/20/03


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
user was?

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.

Thank you,
  Bryan Clauss