<div>
ok, I was reading an artical on database foreign keys and there states (simple talk.com) the artical gave an example of a foreign key constraint being removed and row being added into the referening table only then re-enabling the disabled foreign key without SQL Server performing a check to ensure that the tables involved in the foreign key relationship satisfied the constraints imposed by that foreign key. Apparently you can add the key back but as there is an 'illegal' row the foreign key takes on the status of 'untrusted' in the sysobjects table?
</div>


ok, I was reading an artical on database foreign keys and there states (simple talk.com) the artical gave an example of a foreign key constraint being removed and row being added into the referening table only then re-enabling the disabled foreign key without SQL Server performing a check to ensure that the tables involved in the foreign key relationship satisfied the constraints imposed by that foreign key. Apparently you can add the key back but as there is an 'illegal' row the foreign key takes on the status of 'untrusted' in the sysobjects table?

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
Using the status column of the sysobjects table in sql2000, how do I identifiy foreign key's that are in a so called &quot;untrusted&quot; state?<br />
<br />
Cheers &nbsp;<br />

</div>
</div>


Hi

Using the status column of the sysobjects table in sql2000, how do I identifiy foreign key's that are in a so called "untrusted" state?

Cheers  


status column in sysobjects table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.