Journal Audit Tool 1

[hammer02]

I'm looking for a tool to use over SQL Server that allows for interrogating the database journal to show all changes made to specific records.

I have used a similar tool on DB2 (rptjrn) which is fantastic! It proved invaluable when debugging programs or tracking down production issues.

Is what I'm asking even possible with SQL Server? I don't have much experience with SQL Server (as if you couldn't tell) and am trying to locate a tool like rptjrn.

Thanks!
MH

 

[foxdev]

show all changes made to specific records.

That's a bit tricky. Based on your statement, you want to track only changes made to certain records, rather than all records, within a table.

The only way that comes to mind is to create a trigger for Update, and assuming you can define which records you want to track, the cursor can test if the Deleted record fits that profile and if it does, record the desired info in a second auditing table. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[tlbroadbent]

SQL has no built in journal/audit capability. As suggested, you can create your own through use of Triggers. There are third party tools available which would probably serve your needs. It may be worth your time to check them out. Product reviews are available at the sites. I'm sure there are additional products you can find if you're willing to search.

Intelligent Enterprise

http://www.intelligententerprise.com/000605/products.shtml

HalloGram

http://www.hallogram.com/autoaudit/index.html

Red Matrix Tech

http://www.redmatrix.com/sqlaudit.htm

Terry

http://members.home.net/tlbroadbent/prog.htm

------------------------------------
Experience is the hardest kind of teacher. It gives you the test first, and the lesson afterward.

 

[Guest_imported]

After reviewing the links above SQLAudit looks exactly like the package I was looking for.

Thanks for the info!
MH