Latest Contributions by George_Thompson

Here is an explanation as to why: https://support.esri.com/en-us/knowledge-base/calculate-field-does-not-honor-selection-or-layer-filte-000036268 Related to an issue found with Pro 3.5 and using SQL in Field Calculator: "This issue will be addressed in 3.5 Patch 1 (3.5.1), planned to be available the first week of June 2025. Until a patch is available, the software update service will be disabled in ArcGIS Pro. Customers who understand this issue and the workaround can download ArcGIS Pro 3.5 from My Esri." ... View more

If the feature class is being used in a service, I would stop that service and try to delete. Is the data versioned? If not, you could try to copy out all the good records, then truncate the table (should drop all records). Make sure you have a backup of the data before truncate. This would be the last option I would use. ... View more

I would recommend using AD groups. Add them to the SQL instance, map them to GDB A & B (connect only), then in Pro assign the editing permissions to the groups (this must be done as the feature class owner). That should allow them to just edit data in the allowed feature classes (or related objects). Here is some doc to help with the process:  https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/user-accounts-groups.htm#ESRI_SECTION1_97D393C792C641F8B21706C3ECDCDED6 https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/add-users-sqlserver.htm#ESRI_SECTION1_1EF70F32F80041FB9666781BD3D78754 https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/privileges-sqlserver.htm   ... View more