Results 1 to 2 of 2

Thread: change in a table

  1. 07-15-2004, 05:18 AM #1
    Shaunt
    Shaunt is offline Registered User
    Join Date
    Aug 2003
    Location
    London
    Posts
    110

    change in a table

    Hi,

    Apart of using Triggers

    is there a way with Alerts, so it will notify me when a table has been changed (update,insert)

    many Thanks


    S
    Reply With Quote Reply With Quote
  2. 07-15-2004, 08:48 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Besides trigger, you can run server side SQL trace using stored procedures to log all update and insert activity to a table, then have a job periodically monitor the table and send alerts.

    Other option is to use third party tool like Lumigent Log Explorer or Entegra which gets these information by scanning transaction log.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules