Re: Trigger Status Question

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Scott Morris (bogus_at_bogus.com)
Date: 06/04/04 

Date: Fri, 4 Jun 2004 14:41:49 -0400

IME - this is caused by tasks / scripts initiated and written by a user. I
would certainly suspect any scripts that wipe data from tables as this is
usually the reason for "temporarily" disabling them.

"Sean Newton" <sayno@spam.org> wrote in message
news:%23JU6k$lSEHA.3552@TK2MSFTNGP09.phx.gbl...
> What actions cause sql server 2000 to disable a trigger?
>
> We have noticed in our development environment that, for some unknown
> reason, our triggers become disabled.
> We are not altering table structures that I know of. We are occasionally
> doing a DELETE against all the tables to wipe it clean. There are some
> cascade deletes. I'm just trying to explain what we are doing when the
> triggers will occasionally stop working.
>
> When we rerun our trigger script (drop all the triggers, create them all
> again, enable RECURSIVE_TRIGGERS) everything works fine again. until we
> change a sproc here or there or do a wipe again. rerun script, works fine.
>
> Any ideas?
>
>

Relevant Pages

  • Re: *nix data wipe tools
    ... BCWipe for *nix is a bit complicated for novices. ... automatically do swapoff, mkswap & swapon, so some users will either not wipe ... My humble WipeSwap script -- all eleven lines of it -- will ... My scripts are separate and clearly labeled. ...
    (Bugtraq)
  • Re: Dug myself into several deep holes
    ... run scripts. ... > behavior was caused by the admin, the admin should be able to put things back ... it takes me 30 minutes to do a scripted install and 2 minutes to ... I've got all my dotfiles saved, so after I wipe, I have to do *zero* ...
    (Debian-User)
  • Re: [Full-Disclosure] *nix data wipe tools
    ... > intended as substitutes for the wipe and shred utilities, ... > will easily and securely wipe large areas of the disk that might contain data ... > The scripts are meant to clean large disk areas safely and conveniently while ... > appear to work safely and effectively on a variety of Unix, BSD and Linux ...
    (Full-Disclosure)
  • Re: New Data Wipe Tools
    ... file so that users won't expect too much of the scripts. ... Subject: New Data Wipe Tools ... from the swap partition, wipe unused disk space on the root partition, or ...
    (Bugtraq)
  • Re: How to generate scripts from existing triggers?
    ... Run below to generate the scripts (obviously changing the server and db ... CSCRIPT Server1 pubs CreateTriggers.sql CREATE ... Run the DropTriggers.sql in Query Analyser to drop triggers ...
    (microsoft.public.sqlserver.programming)