Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Use Sql Server log file for audit trail

Status
Not open for further replies.

Mjean

Programmer
Jun 12, 2004
2
US
Is it possible to use Sql Server log files to create an audit trail.

I am thinking of copying the daily log files and then storing data relative to data base changes keyed by user, date, etc (maybe before and after content) for critical files.

I can not find any threads about reading log files. Is it allowed?

Thanks
 
see the log explorer from lumigent.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top