TR_CLIENTUSERS_INSERT
Definition
Copy
CREATE TRIGGER [dbo].[TR_CLIENTUSERS_INSERT] ON [dbo].[CLIENTUSERS] AFTER INSERT NOT FOR REPLICATION
AS
begin
begin
insert into [ClientUserPasswordHistory] ([UserID],[Password])
select INSERTED.ID, INSERTED.password from INSERTED
where INSERTED.Password is not null
end
end