Solved

status column in sysobjects table

Posted on 2008-10-27
2
856 Views
Last Modified: 2012-06-27
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
Comment
Question by:ac_davis2002
2 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 500 total points
ID: 22813054
Im not familiar w/ the "untrusted" state that you're referring ot...
0
 

Author Comment

by:ac_davis2002
ID: 22820418
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question