Delete rows/features from SQL Server spatial

[VytautasGipiskis]

Hello,

Created empty database to store spatial information (no GDB), copied/pasted data into it. Works really nice. Now I want to delete some/all features from this spatial table: tried to use "delete rows"  and "delete features" GP tools -  none of them works, both produces ERROR 999999: Error executing function.
What I'm doing wrong ?

Best Regards,
Vytautas

[JoshuaBixby]

I can't say it directly answers your question, but it might be worth your time to look over the Editing Sql Server without ArcSDE thread in the ArcGIS Desktop forum.

[VytautasGipiskis]

Thanks for pointing this. Just 2 observations:
- Why load (insert) works and delete does not ?
- probably error code 999999 is a most meaningful message after famous ArcView 2.x/3.x "segmentation violation" message.... 🙂

Regards,
Vytautas

[BrentPierce]

Vytautas,

We are working to address issues with the Delete Rows/Features tools when executed against database tables for a future beta release. In the mean time, you should be able to use the Truncate Table GP Tool (Data Management Tools Toolbox > Table Toolset) to truncate the table in the database.

Hope this helps,
-Brent

[VytautasGipiskis]

Hi Brent,
Thanks for update. Can you update GP messages as well ? 999999 is not most informant message 🙂

Best Regards,
Vytautas

[BrentPierce]

Yes, we are also working on providing a better error message when these tools fail. 99999 is only really useful if it's your bank account balance. 😄