22 janvier
SQL Server 2005 :: Transaction Log - Final Part
I came to know that (not surprisingly) you cannot decode the details in MS SQL Server transaction log other than using third party tools like AuditDB, Idera SQL Compliance and so on. These external tools are among the Microsoft wing to provide transaction log information. For others, Microsoft does not give any official support/documentation. Thats the business trick. :)
Okay, beware when you purchase third party tools. Check that whether they support transaction log or use automated triggers for each and every tables in a database?
One good thing I came to know is SoftTree Technologies recently released database auditing API for SQL Server, Oracle and Sybase. (Source: http://snipurl.com/SoftTreeAuditDBAPI). But for this, you have to pay a big amount.
Bye.