SQL transcation log file

5 pts.
Tags:
Log files
SQL
Hi there, I developer is building a commercial application for me.  We are stuck at some point that we seem unable to deal with. The application being built is capable of dealing only with tables with primary keys.  We need it also to handle tables with no primary keys.  For clarity, we have no knowledge of the database structure.  This is supposed to be a universal application (PnP) that can handle any DB schema. As said above, we are unable to find our way out to what records have changed in tables with no primary keys. A suggested solution is to extract entries from the log file.  However, evident as it might be for those who have tried it before, Microsoft seems to prefer to keep everybody’s hands off the log files. I need a way to be able to extract entries from MS SQL log files (those same entries returned by SQL Profiler utility) so to process further them. This question is not points rewarded only, I am willing to pay for it. Regards Yba

Answer Wiki

Thanks. We'll let you know when a new response is added.

You’ll want to look at Lumigent’s Log Explorer and Quest Software’s LiteSpeed for SQL Server. These are pretty much the only two products which allow you to read the SQL Transaction log.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Meandyou
    How can you possibly write an application with no knowledge of the structure of the database? I am unaware of any flavor of the SQL language that will only access tables with a Primary Key.
    5,220 pointsBadges:
    report
  • carlosdl
    How can you possibly write an application with no knowledge of the structure of the database? The application could use the data dictionary to dinamically determine the database structure, and could be using the table/view where primary keys are stored as starting point to access the tables (for some unknown reason)... I'd think that some other solution might exist (apart from reading the log files), but much more details about the application would be needed in order to be able to think about it.
    69,160 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following