AnsweredAssumed Answered

Using Editor Tracking in an Enterprise Geodatabase

Question asked by jborgion Champion on Jun 6, 2017
Latest reply on Jun 6, 2017 by jborgion

ArcGIS Server 10.3, SqlServer 2012 back end.

 

In the past I've used a couple of SQL triggers to update a couple of fields upon editing.  However, I'm embarking on new project and thought I might use Editor Tracking instead.

 

I have an editor field which in the past used the SQL Server user as the update value.  Does Editor Tracking use the SQL User as well?  I've only used ET on one other project and that was with a FileGDB, and it grabbed my domain/login as I recall.

 

With respect to the Date Field, in the past my SQL trigger formatted it for mm/dd/yyyy and I'd like to keep it that way.  Again, it seems in the previous File GDB project, the database time included hours, minutes and seconds, which I don't need or want.  Will Editor Tracking allow for the format I desire?

Outcomes