SDU Tools 150 List Untrusted Check and Foreign Key Constraints in SQL Server
SDU Tools are free tools and example T-SQL code for SQL Server developers and DBAs. We previously provided tools to attempt to retrust untrusted check and foreign key constraints, but we realised we did not have a tool to find them in the first place. One new tool is used to list any check constraints that are currently untrusted. The other new tool does the same for untrusted foreign keys.
To join SDU Insiders and get all our free resources, including SDU Tools, see the details at http://sdutools.sqldownunder.com