By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,215 Members | 1,951 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,215 IT Pros & Developers. It's quick & easy.

audit/history without use of triggers?

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a

"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

P: n/a
thanks Simon for your reply - I'll have a look at entegra

regards
Jul 20 '05 #3

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.