You can find a trigger generator that will make all the code necessary for the triggers.

Or you can build one. It may take a few hours of work, but...

My client has a small in-house system with only 8 users on it, no website. The difference between both trigger system's performance is enough to keep him from buying another...

Fine, turn the trigger back on, then PRINT the query instead of executing it.

Analyse that query and you'll find your problem there.

Also you are asking for troubles by auditing this...

Does it give you that same error even when the trigger is off?

Are you sure that the tables definition match in the base and audit tables (column types AND sizes)?

Do...

Must be a joke, he was one of the founders of the site.

Thanks for the info Gila.

Congrats on the 2K.

Anyone care to guess when we'll hit 100 members in the 2K club??

I'm with you here, I'd like more but I don't have time to think about it.

In the same space I don't have time to come back here and post 4000-5000...

For the records, at least 30 persons reached the crazy levels. However if you only count the forum posts, then my guess is that only 10-15 of those have...

Forum Newbie - 0

Grasshopper - 10

SSC Rookie - 25

Valued Member - 50

SSC Journeyman - 75

SSC-Enthusiastic - 100

SSC Veteran - 200

Old Hand - 300

SSC-Addicted - 400

Mr or Mrs. 500 - 500

SSChasing...

That's why I'm not making a fuss. Next time I need to run a command and change the password, I'll know that it's possible to do it.... that's all...

Ya, -P seems to work as well... and google seems to be in accordance with that!!

This works only if the stats are up to table. It's ok if an estimate is all you need. However if you need accuracy, you need to use...

Tell your boss that you think the data transfer will not fail. Create the view with HIS permission. Be there when the data is reloaded and see what...

This is not even a priority for me. This just chose how much data protection has become a main target for me ;).

I actually found that funny more than...

This is where the experience of the DBA really shows and where our profession shines in all it's glory!!