I have a field in our address point feature class in SDE (SQL) with a numerical (integer) unique ID. I need to either make it autopopulate new records with the next available ID or run a script that will calculate it nightly. Any ideas?
This is a topic that's been discussed for a number of years:
Auto-Increment Field within SDE
Generate an auto populating unique ID field in ArcMap
....
But I just found this with Dr Google: Add Incrementing ID Field—Data Management toolbox | ArcGIS Desktop