Do you know if the most recent version of ArcSDE supports column with IDENTIFY properties? I was just trying to set it up, and when I tried to edit my data in ArcMap I got the same error that you were talking about four years ago .
Take a look at the Water Utility Network Editing solution. Included with this is the attribute assistant add-in. Below is a good help link that walks you through the different methods the add-in provides:
For example, take a look at the autonumber method:
That will only work for the ArcGIS Desktop? Correct? I am trying to get it to work for a feature service that is edited through the Collector app. Thanks, again.