添加金蝶软件触发禁用删除用户激活信息

用户激活信息表是在kdacctdb账套里t_ActivedUser

IF EXISTS (SELECT 1 FROM sys.objects WHERE name = ‘Trigger_ForbidDel_t_ActivedUser’ )

DROP TRIGGER Trigger_ForbidDel_t_ActivedUser

GO

CREATE TRIGGER Trigger_ForbidDel_t_ActivedUser ON t_ActivedUser FOR DELETE AS

RAISERROR(‘不能删除用户注册信息’, 16, 1);

ROLLBACK TRAN

GO