ChangeID alternative bypass.

07/14/2014 17:55 Sicarium#1
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.

[Only registered and activated users can see links. Click Here To Register...]

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.

Code:
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 ;).