Re: Transaction Logs - Viewing

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka@reproms.si)
Date: 03/20/03


From: "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@reproms.si>
Date: Thu, 20 Mar 2003 16:10:30 +0100


Bryan,

Check the Log Explorer tool - www.lumigent.com.

-- 
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Bryan Clauss" <BryanHood1@yahoo.com> wrote in message
news:21b901c2eef1$5da13450$a101280a@phx.gbl...
> 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