CREATE TRIGGER xxxxxx
ON Txxxx
FOR update AS
if exists (select 1 from TRIGGER授权表 where usrname = user_name())
begin
update ...
set ....
--where user_name() <> 'sa'
用了这招你就不必 alter table ... disable trigger all!!!!!
下例: xxxxxx TRIGGER 实际对 sa 无效!
CREATE TRIGGER xxxxxx
ON Txxxx
FOR update AS
update ...
set ....
where user_name() <> 'sa'