SQL Triggers on versioned data

[DougKampe]

I am trying to avoid future problems, so I thought I'd better ask about using SQL programability with a SDE database. What problems (if any) can I incur by using triggers, functions, and stored procedures with versioned SDE data?

If it would be helpful, I could give some specifics on the project I'm working on.

[RobertHu]

Hi Doug,

Depend on what kind of triggers you want to set, put a trigger on a versioned FC can be problematic. A while ago, one of our developers put a trigger on a FC for a test. The FC's maintenance people reported that they recieved errors they never had before and couldn't finished their editing work. As a SDE administrator, I also encountered error message while doing SDE compression, even the compression seemed finishing well. Remove the trigger solved all porblems. It could be just some privilege issue, but we never bother to dig into.

My suggestion would be
1. If you DON'T have to put a trigger on a versioned FC, don't do it! There should be plenty of other ways to do the same thing.
2. If you absolutely need it, do a thorough testing before move to production.

Robert