If the OP really wants to make a log of all transactions, I would create a class that writes to a text file or XML file the details you want to log and build it in to the site/program. That way, when you do any CRUD, you can log exactly what you want.
On Thu, Nov 20, 2008 at 10:47 PM, Stephen Russell <[EMAIL PROTECTED]>wrote: > It is the command and the change that occurs in binary. > > > > ………………………………………………………………… > > Stephen Russell – > > Senior Visual Studio Developer, DBA > > > > Memphis, TN > > 901.246-0159 > > > > > > *From:* [email protected] [mailto: > [EMAIL PROTECTED] *On Behalf Of *Brandon Betances > *Sent:* Thursday, November 20, 2008 5:54 PM > *To:* [email protected] > *Subject:* [DotNetDevelopment] Re: Reading Log from Transaction Log Backup > > > > The T-Log stores queries before they are executed, right Stephen? I know it > has something to do with that, and even if you could parse it, i believe its > all in binary; you wouldnt be able to read it. > > On Thu, Nov 20, 2008 at 10:42 AM, Stephen Russell <[EMAIL PROTECTED]> > wrote: > > > You can't. > > It is a working container for restore functionality. > > There are third party tools that are expensive that will parse the data > within the log and allow you to reverse statements made within the log. > Those are very expensive! > > ......................... > Stephen Russell - > Senior Visual Studio Developer, DBA > > Memphis, TN > 901.246-0159 > > > > > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of Muhammad Arif > Sent: Wednesday, November 19, 2008 11:59 PM > To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web > Services,.NET Remoting > Subject: [DotNetDevelopment] Reading Log from Transaction Log Backup > > > Hello All: > > I have taken backup of my database (Sql server 2000) i-e transaction > log ... now how can i read the log of this backup file... > > Regards > > > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.175 / Virus Database: 270.9.6/1797 - Release Date: 11/19/2008 > 8:58 AM > > > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.175 / Virus Database: 270.9.6/1797 - Release Date: 11/20/2008 > 9:11 AM >
