添加金蝶软件触发禁用删除用户激活信息
添加时间：2022-6-2
用户激活信息表是在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