Re: Transaction Logs - Viewing

From: Dejan Sarka (
Date: 03/20/03

From: "Dejan Sarka" <>
Date: Thu, 20 Mar 2003 16:10:30 +0100


Check the Log Explorer tool -

Dejan Sarka, SQL Server MVP
FAQ from Neil & others at:
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals -
"Bryan Clauss" <> wrote in message
> 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