"John Pan" <panjo03@hotmail.com> wrote in message
news:dc85ec7c.0311261223.48827012@posting.google.com...
> 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

panjo03@hotmail.com (John Pan) wrote in message news:<dc85ec7c.0311261223.48827012@posting.google.com>...
> 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