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

Jul 20 '05 #1

Simon Hayes

"John Pan" <pa*****@hotmail.com> wrote in message
news:dc**************************@posting.google.c om...

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

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

Jul 20 '05 #2

John Pan

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

regards

Jul 20 '05 #3

xAvailx

John:

Check out these products:

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

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

BZ

pa*****@hotmail.com (John Pan) wrote in message news:<dc**************************@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

Jul 20 '05 #4