John Waclawski (10/2/2014)

---

Ed Wagner (10/2/2014)

---

John Waclawski (10/2/2014)

---

Jeff Moden (4/29/2012)

---

adc22 (4/29/2012)

---

1) How to check a trigger is fired or not, while doing database testing?

Same way as when testing any software of old... Add a PRINT or RAISERROR statement to the trigger while testing. 😉

I know this is well over 2 years old, but I'm sure my question is valid for others. Where does this PRINT statement show when you fire off your trigger?

If you're executing your code from SSMS, it prints in the results pane on the Messages tab.

Well that makes too much sense! 😉

Actually it's an application my company writes and when I change a radio button, it makes changes to a certain table & we want to keep track of the changes. I never thought to update that table through SSMS but will do so & test it out.

Thank you!!