When a trigger has an issue connecting to a DB, I need the trigger to automatically disable, then pull a xml from a Windows share drive and insert the name of the trigger into the xml. Then when the trigger is able to later run properly, the code is then supposed to pull the xml from the Windows share drive and remove the name of the trigger.
I believe that I understand what needs to be setup when it comes to making the trigger disable/enable, but can someone point me to what needs to be looked into concerning the insertion/deletion of the trigger name into the already existing xml file?
Again, I’m not creating a new xml file. The file is already existing on a windows share and contains multiple blank tags stating and I don’t want to override any existing tags. It’s fine if new tags needs to be created.
Can you help me or give me some hints please?