Hi Jake,
Do you know if the most recent version of ArcSDE supports column with IDENTIFY properties? It has been three years, and I was wondering it this capability is available now.
George
George Clark this is still unsupported. Looks like there was an idea logged for this on the ArcGIS Ideas page:
https://community.esri.com/ideas/9520
I would recommend voting this up.
Hi Alaeddine,
Currently, ArcSDE doesn't support columns with identity property set to True. Tables/Feature classes with this property cannot be edited in ArcMap or registered as versioned.
When attempting to create non-versioned edits in ArcMap you will receive an error similar to:
"Database Row Change: An unexpected failure occured.
Underlying DBMS error[Microsoft sql server Native Client 10.0: Cannot insert explicit value for identity column in table 'tableName' when IDENTITY_INSERT is set to OFF.][..tableName]."
I'm with Brian. It's simply ridiculous that ESRI STILL does not support a PRIMARY KEY with Identity Column sequence generator in the enterprise database they say the support! If you don't support the primary key you should not say you support the database.
That and the limitation of only being able to have one feature type per table (feature class). All other open source and proprietary geodatabases support this feature and have done so from day 1. ESRI is falling behind in a huge way on many basic levels. It makes developing with their product a nightmare.
Does ArcSDE support columns with identity property set to True yet?