Create SDE Layer as versioned and editable

[SabitaTripathi]

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

[BrentPierce]

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

[SabitaTripathi]

Brent,

We don't have ArcEditor license therefore we can't use ArcCatalog to register as versioned. Can it be done using the ArcSDE layer command?

Sabita

[VinceAngelo]

There are no ArcSDE command-line utilities which change anything managed by ArcObjects
(geodatabases are implemented on top of ArcSDE functionality).

- V

[SabitaTripathi]

vangelo, Thanks for the reply!

So, are you saying we must have a ArcEditor license to make a spatial data versioned and editable? Do we need just the ArcEditor or ArcInfo as well (note that we just have Arcview license currently)?

Is there any other way to create this layer without having to use ArcEditor?

Thanks,
Sabita

[VinceAngelo]

It helps to keep the terminology straight:
+ ArcSDE operates with 'tables' and 'layers'
+ ArcGIS operates with 'feature classes'

Only ArcGIS can register a new feature class in an ArcSDE geodatabase for editing with ArcGIS
(and only with the ArcEditor or ArcInfo license levels).

If you are using ArcGIS 10, you don't need to use ArcSDE to access tables with GEOMETRY/
GEOGRAPHY columns -- instead you can use query layers.

- V