developer.* Blogs - Using an INSTEAD OF DELETE Trigger to Prevent Row Deletions - Comments

Source of row loss

aroggeband — Tue, 23 Jan 2007 12:23:48 -0800

If you open an ADO recordset on a view or select that includes the table, any deletion can result in a cascaded delete on joined tables, even if the view is "not updateable". Try it in Enterprise Manager. MS access also does this with linked tables.

thanks

Guest — Sat, 30 Sep 2006 08:26:21 -0700

just exactly what i'm looking for. very, very useful info. not really easy to find it in the db docs

Using an INSTEAD OF DELETE Trigger to Prevent Row Deletions

Daniel Read — Fri, 03 Mar 2006 16:38:08 -0800

One of my clients had a table that has been mysteriously losing rows. This is a table that does not have any official applications written to delete rows from it, and rows should never be deleted from it. No one can figure out how the missing rows are being deleted. So I added an INSTEAD OF DELETE trigger that raises an error if someone tries to delete a row. It seems to work great.