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.