Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding Not enforced referential relationsships

Status
Not open for further replies.
farhy

farhy

Programmer
Jun 20, 2003
22
AT
Hi,

is there a script to find all "not enforced referential relationsships" in a database, based on data analysis?

There are tools for DB2 which can do that, and I wonder if someone programmed a similar script for SQL Server 2005.

thanx in advance.

br
farhy
 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Will not show row with Line Type 2 1
Replies
17
Views
811
Cpreston
Cpreston
ahmedsa2018
  • Locked
  • Question
How to give same number if it exist on table or new number if it not exist based on part value? 1
Replies
8
Views
448
Andrzejek
Andrzejek
Lidias13
  • Locked
  • Question
Issue trying to find "closest" dated record to a rather complex query (not working)
Replies
1
Views
312
ggriffit
ggriffit
Cpreston
  • Locked
  • Question
Not giving result but NUll
Replies
7
Views
410
Andrzejek
Andrzejek
Auguy
  • Locked
  • Question
SQL 2104 "Check For Updates" Not Listed Under Tools
Replies
0
Views
148
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top