Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 903
  • Last Modified:

status column in sysobjects table

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  
0
ac_davis2002
Asked:
ac_davis2002
1 Solution
 
chapmandewCommented:
Im not familiar w/ the "untrusted" state that you're referring ot...
0
 
ac_davis2002Author Commented:
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?
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now