Error encountered when attempting to create spatial view

[CraigPatterson]

Hi,

I'm trying to create a simple spatial view using the following command:

sdetable -o create_view -t source_fc -T destination_view -c "*" -i sde:sqlserver:server\instance -D database -u username -p xxxxxxx

I'm recieving the following error:
Error: Invalid entity type(-29)
Error: Unable to create view destination_view

I've searched through the forums and the internet, but nearly all references to -29 deal with registering tables, which I don't need to do since the source is already a Feature Class.

Does anyone have any ideas?

Thanks,

Craig

[VinceAngelo]

'sdetable -o create_view' should only be used when the geometry is a SDEBINARY or
SDELOB storage layer.  Views on native geometry or ST_GEOMETRY tables should be
constructed in SQL, then registered with 'sdelayer -o register'.

I strongly advise against using "-c '*'" -- it is best practice to always explicity list
your columns.

An entity type error indicates that your geometry actually contains entities not
supported by your layer.  Native geometries may only contain one topology class
(point *or* line *or* polygon), and should be defined to allow nil geometries --
"np", "nsl+", "na+", respectively).

- V