ChangeID alternative bypass.

[Sicarium]

Hi, this is my changeID bypass made years ago and now I would like share with the community.
Now this problem is fixed but im publishing it for those pp that get this problem yet.



Right button on TCHARTABLE --> Design Table, and now go in Trigger, set all like the image.

Now delete all from Definition and put this script into.

BEGIN
DECLARE @oldID  INT
DECLARE @newID INT

SELECT @oldID = dwUserID FROM DELETED
SELECT @newID = dwUserID FROM INSERTED

IF(@oldID != @newID)
     BEGIN
         ROLLBACK;
     END

END

Now save and test it .