HumanResources.dEmployee Trigger

Information

Name	HumanResources.dEmployee
Table Name	HumanResources.Employee
Created	14.10.2005. 1:59:52
Modified	14.10.2005. 1:59:52
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
    SET NOCOUNT ON;

    DECLARE @DeleteCount int;

    SELECT @DeleteCount = COUNT(*) FROM deleted;
    IF @DeleteCount > 0 
    BEGIN
        RAISERROR
            (N'Employees cannot be deleted. They can only be marked as not current.', -- Message
            10, -- Severity.
            1); -- State.

        -- Rollback any active or uncommittable transactions
        IF @@TRANCOUNT > 0
        BEGIN
            ROLLBACK TRANSACTION;
        END
    END;
END;