Re: Transaction Logs - Viewing
From: Dejan Sarka (firstname.lastname@example.org)
From: "Dejan Sarka" <email@example.com> Date: Thu, 20 Mar 2003 16:10:30 +0100
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:firstname.lastname@example.org... > 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