Has SQL/Server 2005 added any syntax for executing an insert / update or delete and suppressing or bypassing triggers? There are many instances when we are mass updating thousands of rows, and we KNOW we don't need the triggers to run. However, there is no way to bypass the triggers JUST FOR THIS ONE COMMAND. Or is there? Example: insert WITH NO INSERT TRIGGER WITH NO UPDATE TRIGGER returns (month, ror) values ('12/2006',.00123) Or some such syntax, do you know of any solutions?