I have set up DDL events notifications using service broker. I now am trying to set up a trigger on a certain table to fire an email on a new event.
I have one trigger shredding the xml and inserting into certain tables.
I then tried to create a new triggeron a specific table but when I make a change the new trigger is somehow disabling service broker queue. I'm new to tql trigger and service broker. I have gathered the information to build the event data from multiple places on the web. It works, just trying to get the email to send out on change with certain criteria is failing on me. I can add the sql if needed, maybe its the trigger.
Thanks in advance