November 21, 2008 at 10:13 pm
For security and administrative reasons, would like to know that how the data modified firing & committing Transact SQL and later to read data from .LDF file. Based on which analysis can be made.
November 21, 2008 at 11:43 pm
Care to elucidate more on what you are trying to ask?
November 22, 2008 at 12:03 am
The transaction log is not there for auditing purposes. If you're wanting to audit data changes, look at triggers. DML triggers to capture data changes, DDL triggers to capture schema changes.
Or, if you're on SQL 2008, look at Change Data Capture or Change Tracking.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2008 at 12:14 am
Ahh geez, Gail, you're taking the fun out of it! :P;)
November 22, 2008 at 12:25 am
Lynn Pettis (11/22/2008)
Ahh geez, Gail, you're taking the fun out of it! :P;)
Oh, I'm sorry. I'll play dumb next thread... 😉
11pm Seattle time and I'm checking the forums. still on a high from PASS....
Enjoy having the forums to yourself for a couple more days. Things should be back to normal next week.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 22, 2008 at 12:31 am
Gail,
Just checked out your blog and it looks like you had a pretty good and exciting time here in the USA. Have some fun doing the tourist thing in Seattle, and have a safe flight back to SA.
Lynn
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply