SQL Triggers on versioned data

DougKampe — Mon, 18 Jul 2011 12:38:58 GMT

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.

Re: SQL Triggers on versioned data

RobertHu — Tue, 19 Jul 2011 14:33:21 GMT

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

topic SQL Triggers on versioned data in Data Management Questions

SQL Triggers on versioned data

Re: SQL Triggers on versioned data