How can I audit when a Trigger is disabled???

From: MCSA_Todd (MCSA_Todd_at_discussions.microsoft.com)
Date: 05/12/05 

Date: Thu, 12 May 2005 07:09:37 -0700

We are running SQL Server 2000 and are having a problem with database data
being changed. We have a trigger which logs when changes are made and what
the old and new data is. I really need to know if or when someone is
disabling that trigger and changing data. It is possible that the trigger is
being disabled and then the data is being changed and I would like that even
logged and then an operator notified by email.

Any ideas?

Thanks!

Todd

Relevant Pages

  • Re: Need help!!!
    ... I have create a trigger T1 for the table TAB1 in the schema A in the ... TAB2 in the schema B in the database D2. ... Hence I disable the trigger at the remote database and tried to ... This disabling and enabling should occur only when it is coming from ...
    (comp.databases.oracle.server)
  • Need help!!!
    ... I have create a trigger T1 for the table TAB1 in the schema A in the ... TAB2 in the schema B in the database D2. ... This setup was done inorder to update any transaction that happens ... This disabling and enabling should occur only when it is coming from ...
    (comp.databases.oracle.server)
  • Need help!!!
    ... I have create a trigger T1 for the table TAB1 in the schema A in the ... TAB2 in the schema B in the database D2. ... This setup was done inorder to update any transaction that happens ... This disabling and enabling should occur only when it is coming from ...
    (comp.databases.oracle.server)
  • Re: FreeBSD unstable on Dell 1750 using SMP?
    ... The problems I was experiencing were on a dual Xeon with HTT enabled as well. ... Perhaps someone out there who knows much more about the inner workings of FreeBSD may have an idea of why running top in "aggressive mode" like this might trigger the random rebooting. ... In any case, I'm anxious to try it out myself on our server to see if "top -s0" brings it down "on command" with HTT enabled, and not with HTT disabled. ... disabling HTT as I've done seems like a reasonable precaution to improve the stability.. ...
    (freebsd-stable)
  • Re: Disabling triggers
    ... Use the ALTER TABLE DISABLE TRIGGER ... Books Online for SQL Server SP3 at ... "Phil Davy" wrote in message ... > disabling it. ...
    (microsoft.public.sqlserver.programming)