SQL Server tracks untrusted Foreign keys in sys.Foreign keys with a column called is_not_trusted, there may be a number of reasons why a Foreign key may have become untrusted below are a couple of examples:   Foreign key was disabled using the 'NOCHECK' option then re-enabled using 'CHECK' (not to be confused with 'WITH CHECK') Foreign key was... Continue Reading →