Triggers SQL 2005 Adventure Works OLTP

HumanResources.dEmployee

Object type: Trigger

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 

Applies to

Triggers | Transactional | On delete | Instead of table changes
The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation

Document was prepared on: Thursday, April 05, 2007
Help compiled by DBDocumentor, a Pikauba Software product. All rights reserved.