I am developing a project that connect to a SQL 2005 database which has 60 related tables. I use Power Designer for design my database. when i finish and try to create it. i got alot of "cause cycles or multiple cascade paths".
I searched, and i find that i have to create one CASCADE. the others must has no CASCADE.
Is there anyway to help me in this.
here is a sample of my database
it is not easy to redesign and recreate many triggers.
Thanks in advance.