I'm trying to determine the trigger order for a table with eight triggers...and somehow find an answer to someone's question about a data change.
How's your day?
@DaveMasonDotMe Better than many of the recent days.
Doesn't help you right now, but is the sql version new enough you could make it a temporal table? That will track the order of changes for you.
Follow
@Leemarkum Yes, that's a great option for going forward...if I can get buy-in from the rest of the team.
The problem is past events. I can't put the toothpaste back in the tube, so to speak.