TR_CLIENTUSERS_UPDATE

Trigger Definition

			CREATE TRIGGER [dbo].[TR_CLIENTUSERS_UPDATE] ON [dbo].[CLIENTUSERS] AFTER UPDATE NOT FOR REPLICATION
			AS
			begin
				if (update(PASSWORD))
				begin
					insert into [ClientUserPasswordHistory] ([UserID],[Password]) 
						select INSERTED.ID, INSERTED.password from INSERTED inner join DELETED on INSERTED.ID=DELETED.ID
						where DELETED.Password<>INSERTED.Password and INSERTED.Password is not null
				end
			end