Agree with Blindman. If you have a broken trigger you should fix it. If you have trigger code that isn't applicable to every single insert then it shouldn't go in a trigger.
It's amazing how many triggers I see with all sorts of complex logic that really should never be inflicted on every user, developer or DBA who wants to insert a row. The best place to put any code that modifies data in any way is to put it in a stored procedure, not in a trigger.
Ufortunately that ALTER command is scoped to the table, not just your transaction, so all users in the database will be affected. This is why you should think very, very carefully before you put any code at all into a trigger.