Triggers | SQL 2005 Adventure Works OLTP |
INSTEAD OF DELETE trigger which keeps Employees from being deleted.
Summary
On table: Delete Update Insert Type HumanResources.Employee Yes No Yes Instead of
Properties
Modifies data Transactional Uses cursors Executes procedures Dynamic content Encrypted No Yes No No No No
Errors raised
Message ID Severity State Employees cannot be deleted. They can only be marked as not current. 50000 10 1
Applies to
Triggers | Transactional | On delete | Instead of table changes