Mike,
Sergey showed you how to do it, but disabling the trigger isn't going to violate any of the business rules that require the trigger to have been put there in the first place?
>I am running an insert stored procedure but have a trigger set for one of the tables. When the insert store procedure runs it fires the trigger. Is there a way to tell SQL not to fire the trigger or ignore the trigger for that stored procedure without having to drop and reload the trigger.