Losing RI Relationships!!!

  • Has anybody had any problems losing ri relationships on sql server 2000 sp 3a? I have a feeling that there are problems editing relationships with the diagram tool. The only change we have made to the tables is re-seeding the identities by taking the identity off and then reinstating it.

  • seems to be happening on tables with cascading deletes on the relationship. when i go into the diagram the relationship disappears. when i take off the cascading deletes it stays.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply