HumanResources.dEmployee Trigger
Information
| Name | HumanResources.dEmployee |
| Table Name | HumanResources.Employee |
| Created | 29.3.2010. 21:58:56 |
| Modified | 29.3.2010. 21:58:56 |
| Disabled | |
| For replication | |
| Instead of trigger | |
| Activates on | DELETE |
SQL Script
CREATE TRIGGER [HumanResources].[dEmployee] ON [HumanResources].[Employee]
INSTEAD OF DELETE NOT FOR REPLICATION AS
BEGIN
DECLARE @Count int;
SET @Count = @@ROWCOUNT;
IF @Count = 0
RETURN;
SET NOCOUNT ON;
BEGIN
RAISERROR
(N'Employees cannot be deleted. They can only be marked as not current.', -- Message
10, -- Severity.
1); -- State.
IF @@TRANCOUNT > 0
BEGIN
ROLLBACK TRANSACTION;
END
END;
END;
