Having SQL Triggers on the Adds tables for SDE feature classes/tables is very useful. For example, you can have an automatically updated timestamp field or a field that automatically populates the username of the current editor. Unfortunately, SQL triggers are currently not supported and if you have a versioned SDE environment and/or geodatabase topology, if you need to unregister as versioned or make changes to the topology, you have to recreate the triggers on the Adds tables. If triggers were supported, then perhaps this phenomenon wouldn't have to occur.
