I am using the direct connection to connect to the Arcsde (Sqlserver 2008) database. I created a spatial table and registered it as a layer using sde command. Now, I want to create service that will allow us to edit the layer in database (Feature Access Service). But I keep getting an error and on the desktop when I try to edit the layer it prompts a message "layer is not editable and it's not versioned". See the attachment.
So, the question is:
a) How do I register layer as versioned? It failed with sde -o register ...-V command
b) How do I create a layer that's editable? Note: I have already added ArcGISSOC account in sql server and grated a read/write permission.
Thanks,
Sabita
So, the question is:
a) How do I register layer as versioned? It failed with sde -o register ...-V command
b) How do I create a layer that's editable? Note: I have already added ArcGISSOC account in sql server and grated a read/write permission.
Thanks,
Sabita
If you Open the Geodatabase in ArcCatalog you should be able to right click on the feature class or table in question and select "register as versioned". Once the class is versioned you should be able to start a versioned edit session on the class in desktop.
Hope this helps,
-Brent