audit/history without use of triggers?

[John Pan]

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

[Simon Hayes]

Re: audit/history without use of triggers?


"John Pan" <panjo03@hotmai l.com> wrote in message
news:dc85ec7c.0 311261223.48827 012@posting.goo gle.com...[color=blue]
> 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[/color]

There's nothing in SQL Server itself, but there is at least one third party
product available which looks like it may meet your requirements:

http://www.lumigent.com/products/entegra/entegra.htm

Simon

[John Pan]

Re: audit/history without use of triggers?

thanks Simon for your reply - I'll have a look at entegra

regards

[xAvailx]

Re: audit/history without use of triggers?

John:

Check out these products:

http://www.apexsql.com/index_lognavigator.htm

http://www.lumigent.com/products/le_sql/le_sql.htm

HTH,

BZ

panjo03@hotmail .com (John Pan) wrote in message news:<dc85ec7c. 0311261223.4882 7012@posting.go ogle.com>...[color=blue]
> 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[/color]