Another thing that would be inconvenient to using a trigger would be that is a user is a sysadmin, they could also disable or drop the trigger and then do whatever they wanted anyway. Like was pointed out before:
spaghettidba (10/31/2013)
If they don't have that right, they shouldn't be sysadmin in the first place.