Using transaction log to alert users to status changes

• Carl Grant

  SSChasing Mays

  Points: 612

  More actions

  November 10, 2005 at 12:38 pm

  #169733

  I'm looking for an alternative to triggers that will allow me to alert users to certain changes in a database. Is there any way to do this by using the transaction log?

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  November 11, 2005 at 4:42 am

  #603389

  You'll not want to interactively query the transaction log - not a good idea.

  It really depends what it is you're trying to trap. Using code is probably best - a job which runs every minute or so ?

  You can log many events ( via alerts ) which you could get to fire off an email.

  I agree with trying to avoid triggers, they can really impair your database performance.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/