Question: Use Trigger to Prevent Deletes with no Where Clause?

Hi all. We recently discovered a bug in one of our applications (it's in Visual Basic; we inherited it) that under an obscure set of conditions executes a "DELETE FROM [table]" without a where clause. We can fix the app, but getting it certified for use takes time; however, I can make various administrative changes to the database however without approval.

My question is, can I use a "before" trigger to detect the mass "DELETE FROM" statement and prevent it from executing?

Thanks.

Jesse Received on Thu Jan 13 2005 - 13:24:28 CST