A script to check for orphans

Hello - I'm using sql 2005 and I am searching for a way to write a sql script

that could check the relationships between all tables in a database and

return results of if there are any child or parent orphans.

Is there a system stored procedure that would return results of all tables

and their PK - FK relationships that I may be able to use to write this

script? or even something that may already exist that does what I'm trying to

do?

Thank you!

mgm

http://sql.itags.org/q_sql_1124.html