SQL Server 2008 with Geometry or Geography storage only: Executing "sdetable -o create_view" against a feature class in SQL Server 2008 will return the error "DBMS table not found" if ALL of the following are true:
• A feature class involved in the view uses GEOMETRY or GEOGRAPHY storage.
• A feature class involved in the view is enabled to store CAD data. (Note: All feature classes created through ArcGIS Desktop are automatically enabled to store CAD data.)
• The sdetable –o create_view command is executed as a user that has been granted SELECT permission on the underlying feature class and tables but does not own them.