I am wondering if it is possible to create a delete trigger that display a warning message when a delete operation is carried on more than one record and gives us the option to cancel or continue with the deletion?
I created the following delete trigger on the Employees table that cancels any delete operation involving more than one record, I need to take it up further and have it produce a warning with a cancel/continue option.
Create Trigger tgr_delEmployees on Employees
After Delete AS
if ((Select count(*) from Deleted) > 1)