How to delete data from MS SQL Server using Delete from Data Store Entities Smart Service ?

Here are a few quick thoughts....

(1) Run it as who started the process to make sure they have permissions to do so
(2) Ensure cascade is in place, otherwise delete from child up
(3) If you are giving this priv to a lot of people, keep an audit log table as the process instance that does the delete will archive or delete based on data mgmt strategy

ChristineH I would suggest cascade delete should almost never be in place - it's useful in only a few, very specific, scenarios.

Fair point , as you must be very careful with the 'power' that comes from cascade delete.

When I have a lot of related tables to delete from, I like to create a stored procedure to do so. That way I can control order, querying for keys, rollbacks, any logging, etc., but maybe that is because I am comfortable working in the DB, as cascade delete is not set on many of my tables.

Fair point , as you must be very careful with the 'power' that comes from cascade delete.

When I have a lot of related tables to delete from, I like to create a stored procedure to do so. That way I can control order, querying for keys, rollbacks, any logging, etc., but maybe that is because I am comfortable working in the DB, as cascade delete is not set on many of my tables.

ChristineH I much prefer logical deletes, that way you can always get the data back :D