Now, the foreign key is enabled, but it’s not trusted. The errorlog will not show you this. There’s no mention of the foreign key losing it’s trust. It’s just… gone. I checked the default extended events as well, no mention there.
Read on to understand why this is a bad thing and two options to prevent it.