multiple cascade path

• elham_azizi_62

  SSCertifiable

  Points: 5095

  More actions

  March 1, 2011 at 11:33 pm

  #232776

  hi all.

  we have many tables wich have forein key columns with multiple cascade path error.

  I want to find reason of this cycles by script.is there any way fo finding this cycles whit script?pleas give me this script.

  thanks

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  March 2, 2011 at 10:09 am

  #1293608

  This may help you get started:

  http://www.sqlservercentral.com/scripts/foreign+keys/69110/[/url]

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato