I have checked all of the options in the reverse engineering dialog
boxes...they all come out onto my visio drawing but they do not have
arrows or lines connecting them? did I choose too many options?? I have
over 200 tables that are linked multiple times, so manually linking each
one of them is really going to be a long and tiresome project...I might
as well draw the entire DB from scratch...Any other suggestions?? or did
I read your answer wrong?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Well it doesn't look good, seems that the database does not have foreign
key constraints, does this mean I am out of luck??? we do have an old
printed map of the database done in enterprize manager that seems to
have foreign keys mapped. does this seem odd??? maybe someone just had
so much time on their hands they did them all manually. Well if this is
the case and I am out of luck any suggestions to help speed this process
up????


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Unfortunately yes. You will have to rebuild FKs.

Diagrams are not updated automatically when schema is updated, so someone
might drop constraints after the diagram was created as well.

I don't think there is better method than adding the FKs manually. This is
an important issue, so don't hurry.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

Thank you for your assistance, It is very much appreciated. I will
proceed with the FK mapping at a normal pace. Thank you again Dejan for
all your help!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!