idea Support SQL Triggers in ArcSDE in Data Management Ideas https://community.esri.com/t5/data-management-ideas/support-sql-triggers-in-arcsde/idi-p/953871 <P>Having SQL Triggers on the Adds tables for SDE feature classes/tables is very useful.&nbsp; For example, you can have an automatically updated timestamp field or a field that automatically populates the username of the current editor.&nbsp; 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.&nbsp; If triggers were supported, then perhaps this phenomenon wouldn't have to occur.</P><!-- content transformation source ID: 0873000000088Vg --> Mon, 29 Aug 2022 23:44:05 GMT DamonPettitt 2022-08-29T23:44:05Z Support SQL Triggers in ArcSDE https://community.esri.com/t5/data-management-ideas/support-sql-triggers-in-arcsde/idi-p/953871 <P>Having SQL Triggers on the Adds tables for SDE feature classes/tables is very useful.&nbsp; For example, you can have an automatically updated timestamp field or a field that automatically populates the username of the current editor.&nbsp; 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.&nbsp; If triggers were supported, then perhaps this phenomenon wouldn't have to occur.</P><!-- content transformation source ID: 0873000000088Vg --> Mon, 29 Aug 2022 23:44:05 GMT https://community.esri.com/t5/data-management-ideas/support-sql-triggers-in-arcsde/idi-p/953871 DamonPettitt 2022-08-29T23:44:05Z Re: Support SQL Triggers in ArcSDE https://community.esri.com/t5/data-management-ideas/support-sql-triggers-in-arcsde/idc-p/953872#M1068 <HTML><HEAD></HEAD><BODY>Check out the Tax Parcel Editing toolbar. It has a lot of this functionality. <!-- content transformation source ID: 00a30000006zfDG --> </BODY></HTML> Tue, 18 May 2010 18:06:04 GMT https://community.esri.com/t5/data-management-ideas/support-sql-triggers-in-arcsde/idc-p/953872#M1068 BrettLord-Castillo 2010-05-18T18:06:04Z Re: Support SQL Triggers in ArcSDE https://community.esri.com/t5/data-management-ideas/support-sql-triggers-in-arcsde/idc-p/953873#M1069 <HTML><HEAD></HEAD><BODY>There are many uses for this functionality that are not included in a Tax Parcel Editor. If we had direct support for Database Triggers the possiblities would be endless. <!-- content transformation source ID: 00a30000007Js2u --> </BODY></HTML> Fri, 02 Jul 2010 20:15:19 GMT https://community.esri.com/t5/data-management-ideas/support-sql-triggers-in-arcsde/idc-p/953873#M1069 BryanHall2 2010-07-02T20:15:19Z Re: Support SQL Triggers in ArcSDE - Status changed to: Already Offered https://community.esri.com/t5/data-management-ideas/support-sql-triggers-in-arcsde/idc-p/1292860#M2217 <P>Editor Tracking and Attribute Rules provide this functionality.</P> Wed, 24 May 2023 22:25:46 GMT https://community.esri.com/t5/data-management-ideas/support-sql-triggers-in-arcsde/idc-p/1292860#M2217 ShannonShields 2023-05-24T22:25:46Z