How to change a layer from LOAD mode to Normal mode in SQL server

Question

Hi dear:

I have created a feature dataset in SQL Server 2008R2 and assigned to a non-version edits. I am not able to do any edits, I have seen many threads to do that using commands line tool, in my case I am using 10.1 and I am using Direct Connection mode without installing ArcSDE Command Tool software. The feature class that I created based on a Load  from an existing feature classes. How to solve my issue to edit this feature classes now?

Note: I have unchecked the box of Edit a version of the database with the ability to undo and redo.

Many thanks!

Asrujit_SenGupta · Answer

If the Feature Dataset was versioned previous to adding this new Feature Class, then it is a mix of Versioned and Non-Versioned data inside that Feature Dataset, which can lead to that error.

Did you try the below:

Just for testing, create a new Feature Dataset, import only this Feature Class in it and then try to start a Non-versioned editing session on that.

AburowaH · Answer

Thanks Asrujit,

- Yes, its only one layer added to the map document.

- I am not sure if I register this database as versioned first, but currently its non-versioned, I will assume that it's versioned originally, and currently I would like to find a solution for it as this feature class its working in production environment and it's linked with many applications and services.

Asrujit_SenGupta · Answer

Error: Start editing encountered one or more layers with errors or warnings and cannot continue. Incorrect edit version …

* Is that the only layer in the Map Document?
* Was the Feature Dataset registered as Versioned, and you created this new Feature Class?

Just for testing, create a new Feature Dataset, import this Feature Class in it and then try to start a Non-versioned editing session on that.