Detect invalid FK-data after using "WITH NOCHECK"

In situations where FK's have been created using the "WITH NOCHECK" option you can get into troubles because the FK-data is not checked ! (so there may be invalid data in the FK-column !)

E.g. ALTER TABLE [dbo].[mytable] WITH NOCHECK add constraint [FK__USED_RESO__Actio__1162CF5F] FOREIGN KEY ( Action_Type ) REFERENCES [dbo].[Action_Types] ( Action_Type )

BOL states "... If you do not want to verify new CHECK or FOREIGN KEY constraints against existing data,
use WITH NOCHECK.
We do not recommend doing this, except in rare cases. ..."


I've commented the proc because I found the DBCC command that does even more than that !