---

SQL Server triggers execution precedence View(s): 19375 I had created two update triggers for two columns in a table. When i use update statement on this table on which order or precedence trigger will fires? Answer 1) There is no guarantee as to what order they'll fire in.  But still you can use sp_settriggerorder to define the first and last trigger to execute. For the rest the order is undefined. If precedence is matters to you then put all the logic in one trigger. Answered by Mr. Ponna   Asked in:  TCS (Tata Consultancy Services)   Expertise Level:  Experienced   Last updated on Sunday, 23 October 2011 4/5 stars (13 vote(s))