How to Automate Lat/Long Coordinates when new a feature is created?

Question

I am attempting to have the latitude & longitude fields be automatically populated when a user adds a new point feature via my web application.  I am using a SDE point feature service with ArcGIS Server 10.2.2 with SQL Server 2012.  I have come across some comments that it might be able to employ a SQL Server trigger in the table but I have no experience with triggers or how to code it. Basically if anyone has any information they can point me to would be much appreciative.

-Thanks

ThomasColson · Answer

Using SQL to Auto-Populate XY Values

JoeBorgione · Answer

Here's another link you should consider: SQL Trigger in Versioned SDE

This is basically what I've been doing with two fields since version 8.3 and SQL 2005.  My write ups on sql triggers were on the old forum, and they don't seem to be available to a google search.

KelseyNovacek1 · Answer

I have included the code from the link into my trigger folder in SQL Server.  The Latitude and Longitude data is only added after I manually execute the code and refresh my edits.  Do you know how to get the trigger to execute automatically as soon as a point is created?