Home > IT Answers > Networking > SQL transcation log file
Yba
5 pts.
 SQL transcation log file
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

Software/Hardware used:
ASKED: January 20, 2010  4:58 PM
UPDATED: January 22, 2010  4:52 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  January 20, 2010  8:45 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

Meandyou
 5,205 pts.
 

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.

carlosdl
 63,535 pts.