Solved

status column in sysobjects table

Posted on 2008-10-27
2
862 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Re-appearing SQL Server Agent jobs 7 29
SQL Server / Update DB? 22 36
SQL Recursion 6 18
SQL View / Qtry 3 11
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

860 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