Hi
I am looking to implement an audit/history table/tables but am looking
at doing this without the use of triggers.
The reason for doing this is that the application is highly
transactional and speed in critical areas is important.
I am worried that triggers would slow things down.
I am more used to other database where by there is a utility to "dump"
the contents of the transaction logs and use this for auditing
purposes. However SQL Server does not have this functionality (unless
there is a sql server tool - 3rd party that I do not know about)
Has anyone implemented something similar? Or used/using a 3rd party
tool that will do this job.
Effectively the clients would like to "look" at what happened - say 15
minutes ago.
thanks
john