Not sure where to post this; can't seem to find an appropriate Place, and I have searched all over trying to find an answer
I have an SQL EXPRESS 2012 instance that has been enabled for geodatabases and have 2 geodatabases in it that work fine. In the same instance, I recently added another database (non-spatial) that I created in SQL Server Management Studio for which I have made a Database Connection. I can add a table from this non-spatial database to the map and I can join geodatabase tables to it, but I cannot edit it. Is there something wrong in the way I have set it up, or is this the way things work?
If it is non-editable in ArcGIS, what would be the best way to handle the scenario where data from a geodatabase table is needed to up-date the non-spatial database table, and vice versa? (The non-spatial database's primary function has nothing to do with ArcGIS, but I would like to be able to work with one particular table from it.)