how much do you have?

[megaadam]

You obviously need one table per trigger to keep track of them. Then add a trigger for each table if any trigger changes. FTFY.

... such stuff as dreams are made on

[Kornfeld Eliyahu Peter]

Isn't it 100%? :-)

Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.

[Kornfeld Eliyahu Peter]

Actually some of the triggers are there to log data changes (on important tables)... Others are for data integrity... And others are for sync with externals...

Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.

[Lost User]

Yes but it's also 42%, and 9001%, etc..

[ZurdoDev]

Kornfeld Eliyahu Peter wrote:

(~23%)

We got you beat. 247 triggers on 741 tables, exactly 1/3, although not intentional.

There are two kinds of people in the world: those who can extrapolate from incomplete data. There are only 10 types of people in the world, those who understand binary and those who don't.

[Lost User]

I avoid them as triggers too easily lend themselves to database-vendor specific code.

Installing Signature... Do not switch off your computer.

[Pualee]

I'd start looking for a new job before the house of cards falls down.

[CodeWraith]

My former bosses have about 10 - 15 triggers on each and every table, some of them thousands of lines long. A nightmare. Especially after that experience: 0.0 triggers per table and not a single trigger more.

I have lived with several Zen masters - all of them were cats.

[Kornfeld Eliyahu Peter]

That sounds awful... Our triggers are short (sometimes 2-3 triggers on the same event, just because they all do something else)...

Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.

[CodeWraith]

The major part of the application logic took place in those triggers. Guess why I run out of job interviews when I hear 'Access' or ' Former Acess project that has ben ported to xxx'.

I have lived with several Zen masters - all of them were cats.

[abmv]

Lotta time I see...

Caveat Emptor. "Progress doesn't come from early risers – progress is made by lazy men looking for easier ways to do things." Lazarus Long

[Dave Kreskowiak]

I've used 2 in my entire 32 years of doing this crap.

System.ItDidntWorkException: Something didn't work as expected. A guide to posting questions on CodeProject

Click this: Asking questions is a skill. Seriously, do it.
Dave Kreskowiak

[megaadam]

Sounds like a bunch of trigger happy bosses :suss:

... such stuff as dreams are made on

[R Giskard Reventlov]

Zero. Who needs 'em, eh?

[Kornfeld Eliyahu Peter]

Working on a review of the DB design to suggest improvements...

Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.

[Slacker007]

CodeWraith wrote:

My former bosses

Database guys in charge of application development? Sounds like it to me.

[PIEBALDconsult]

Zero. Though I may have written one about ten years ago. Only as a convenience for debugging. It was not vital to the system.

[Jeremy Falcon]

Surely that would affect performance to have that many? Most DBs I've worked on tend to not have more than a few tops.

Jeremy Falcon

[CodeWraith]

Even worse. Access guys in charge. I must have offended him when I looked at that stuff and asked him what this particular form of insanity is called.

I have lived with several Zen masters - all of them were cats.

[Mycroft Holmes]

:sigh: I hate triggers spit Development - 0 triggers UAT and Production 3 triggers on each of the master tables. I have a script that uses a configuration table to create and remove audit triggers on selected tables for each database. As we have approx 15 databases, any 3 of which will be deployed to production in any month this script is a life saver.

Never underestimate the power of human stupidity RAH